Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Global Temporary table

710428Jul 6 2009 — edited Jul 6 2009
I am new to Oracle and using a temp table.

This is my TEMP table.

CREATE GLOBAL TEMPORARY TABLE tt (
c1 int not null
)on commit preserve rows;

After I create temp table, I can find from DBA_TABLES that TEMPORARY flag is set to 'Y'. Where does on commit preserve rows info is stored in the dictionary tables? After I get that info from catalog, can I alter this temp table dynamically to switch from preserve to delete rows.

Your help is appreciated.

Vikram Kumar
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 3 2009
Added on Jul 6 2009
3 comments
712 views