Using the global temporary table emulation

The global temporary table emulation is provided to get benefit of the Oracle GLOBAL TEMPORARY TABLES, by sharing the same table structure with multiple SQL sessions, reducing the cost of the CREATE TABLE statement execution. However, this emulation does not provide the same level of Informix® compatibility as the default emulation, and must be used carefully.

How does the global emulation work?

Prerequisites when using the global emulation

Limitations of the global emulation

Creating indexes on temporary tables with global emulation

SERIALs in temporary table creation with global emulation