Restrictions on Declared Global Temporary Tables

Sunday, 7 April 2013

Restrictions on Declared Global Temporary Tables


You cannot use the following features with temporary tables:

Synonyms, triggers and views on SESSION schema tables (including physical tables and temporary
         tables)
Caching statements that reference SESSION schema tables and views
Temporary tables cannot be specified in referential constraints and primary keys
Temporary tables cannot be referenced in a triggered-SQL-statement
Check constraints on columns
Generated-column-spec
Importing into temporary tables

If a statement that performs an insert, update, or delete to the temporary table encounters an error, all the rows of the temporary table are deleted.

The following data types cannot be used with Declared Global Temporary Tables:

BLOB
CHAR FOR BIT DATA
CLOB
LONG VARCHAR
LONG VARCHAR FOR BIT DATA
VARCHAR FOR BIT DATA
XML

No comments:

Post a comment