Access Oracle GTT table data from another session

oracleoracle-10gtemporary-tables

I have using Oracle GTT tables with condition ON COMMIT DELETE ROWS.

Now i know GTT tables data is only session specific. 1 session cannot see the GTT data of other session in General.

But is their any way to access/read GTT table that belongs to another session?

Best Answer

No that is not possible, only session accessing the GTT can see it. IF you wish, you can use a physical table and model it as if it s a GTT. It isn't difficult, but isn't very efficient either.