Thanks for your feedback.
According to Oracle 11.2 docs, global temporary tables cannot use segment creation deferred option. (docs.oracle.com/…/statements_7002.htm You cannot defer segment creation for the following types of tables: index-organized tables, clustered tables, global temporary tables, session-specific temporary tables, internal tables, typed tables, AQ tables, external tables, and tables owned by SYS, SYSTEM, PUBLIC, OUTLN, or XDB.)
We add SEGMENT CREATION IMMEDIATE to the DDL when the result of the query below return YES:
WHERE table_name LIKE :tablename
(docs.oracle.com/…/statviews_2117.htm SEGMENT_CREATED VARCHAR2(3) Indicates whether the table segment is created (YES) or not (NO) )
When user creates a global temporary table in 11gr2, no matter SEGMENT CREATION IMMEDIATE is specified or not, We always see YES in the result above. We understand there is no segment created for temporary table, but the DDL we generate for it reflects the truth of the table information Oracle stores.
If you still have any concern regarding this option, please let us know.