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!

Data dictionary view for Global Temporary Table

Arun Kumar GuptaMay 4 2020 — edited May 4 2020

Hello Everyone

Database Version : Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Global temporary tables can be defined as ON commit Delete Row and On commit Preserve Rows.

I am just wondering which data dictionary view has this information.

dba_tables (user_tables) has a column TEMPORARY with values as Y and N, to identify whether a table is temporary table or not but could not find any view which has the above said property of GTT.

Regards

Arun

This post has been answered by BEDE on May 4 2020

Jump to Answer

Added on May 4 2020

5 comments

4,775 views