How do Global temporary tables work ?
I have read that GTT are private,session specific or transaction specific.
Ex:
I have 2 users logged into the database
Users:A and B
A opens 2 sessions AS1,AS2 and B opens 2 sessions BB1,BS2.
I have read that Global temporary tables are session specific.
1.So is the GTT created by user A only visible to AS1 and AS2 ?
and similarly GTT created by user B only visible to BS1 and BS2 ?
Or GTT created by user A in sessions AS1 available to A in ONLY AS1 ?
2.Any user logged into the database can he create more than 1 GTT ?
3.Or are GTT created in different sessions visible to all users logged into the oracle database in other sessions?
4.Are GTT just visible or can other users open and access the data in the GTT created by other users ?
Can I get scenarios where GTT can be used ?
Message was edited by: KMWS