-1

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

Generally GTT table's data is only session specific. One 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? Is there some kind of global session.

Lalit Kumar B
  • 47,486
  • 13
  • 97
  • 124
Dhruv
  • 10,291
  • 18
  • 77
  • 126
  • 2
    You already asked this here: http://dba.stackexchange.com/questions/89919/access-oracle-gtt-table-data-from-another-session ; what don't you understand from the answer? – Mat Jan 23 '15 at 05:53

1 Answers1

2

In plain words, NO.

The definition of a temporary table is visible to all sessions, but the data in a temporary table is visible only to the session that inserts the data into the table.

Just think, if the data is visible to other sessions, the purpose of a GTT is defeated.

Lalit Kumar B
  • 47,486
  • 13
  • 97
  • 124