Oracle Database Discussions

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!

Viewing Data in Global Temporary Tables

Simon TannNov 10 2010 — edited Nov 10 2010

Hi,

We have three environments - DEV, QA and Production. During development and QA it would be useful to be able to view the data held in a Global Temporary Table for another session. For example, if we run something in one of our applications that populates the table it would be useful to interrogate that data from a Toad / sqlplus session for debugging purposes.

Other than converting the GTT to a normal table in DEV and QA, is there any way to access this data?

Cheers

Simon

This post has been answered by Renjith Madhavan on Nov 10 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2010

Added on Nov 10 2010

#database, #general-database-discussions, #sql

4 comments

632 views