Tuesday, March 9, 2010

create oracle global temporary table

Global temporary table is only used in Oracle Transaction.
When the transaction committed or rolled back, the temporary table disappeared.

CREATE GLOBAL TEMPORARY TABLE table_name ...


You can found this global temporary table's name in the dba_objects, as a table, but there is no information in dba_segments or dba_tables.
And, of course, you can found the real object in temp tablespace by querying v$sort_usage.