Does DDL for creating Oracle temporary tables commit transaction?

Question

How can I create a temporary table in Oracle db (CREATE GLOBAL TEMPORARY TABLE) without the DDL to commit the transaction?

I want the same behavour like on MySQL. From here:

CREATE TABLE does not automatically commit the current active transaction if you use the TEMPORARY keyword.

Answer 1

Yes, DDL commits your transaction.

In addtion to Franek's answer, I want to point out that you should not need to create a global temporary table on the fly as all data within such a table is private to the session that inserted it.

So, if you create the global temporary table once, your session can safely use this table without fear of interfering with other sessions, and the ddl-commit issue becomes non-relevant.