Online Documentation for SQL Manager for Oracle

Global Temporary


A iconObjects_Table_GlobalTemporary Global Temporary table is a temporary table and its definition is visible to all sessions with appropriate privileges. The data in a temporary table  are visible only to the session that inserts the data into the table.

 

Table properties - Global Temporary

 

The following type-specific properties can be set for Global Temporary tables:

 

Duration

The table segment and any data the table contains can be either session-specific or transaction-specific data. Use this group to specify whether the table segment and data are session- or transaction-specific.

 

On commit

This group specifies action performed over the table data on commit:

RadioButton Delete rows

This option is specified for a transaction-specific temporary table. Oracle will truncate the table (delete all its rows) after each commit.

RadioButton Preserve rows

This option is specified for a session-specific temporary table. Oracle will truncate the table (delete all its rows) when you terminate the session.