Clarification in Global Temporary Tables

Database
Enthusiast

Clarification in Global Temporary Tables

Hi All,

I have a global temporary table Table_A and If am loading this table in a session1 and at the same time if I am trying to Select data or insert data from\into the same global temporary table Table_A in session2,what will be the consequences?

In session2 Will it select/insert the data from/to the table which has the data of session1?

Thanks,
Ashok.
3 REPLIES
Enthusiast

Re: Clarification in Global Temporary Tables

each session will have it's own data.In GTT data will not be shared across sessions.
Enthusiast

Re: Clarification in Global Temporary Tables

Only Table is shared across the sessions.

Few Imp points with respect to GTT:

Data inserted in a session is not shared with the other session.
Data Loaded in a session will be deleted if the session is closed.
You can apply stats on the data that is inserted.
Enthusiast

Re: Clarification in Global Temporary Tables

Thank you for the explanation.