A global temporary table is a type of table in Oracle that holds data only for the duration of a session or transaction. It is a persistent database object, visible to all sessions, until the user drops it explicitly using the DROP TABLE statement. Data is only visible to the session which inserts it. The data stored in the global temporary table is private to the session1.
In contrast, a regular table is a permanent database object that stores data on disk and is visible to all sessions. The data stored in a regular table is not private to any session and can be accessed by any session with the appropriate privileges.
In summary, the main differences between a global temporary table and a regular table are:
A global temporary table holds data only for the duration of a session or transaction, while a regular table holds data permanently.
Data stored in a global temporary table is private to the session, while data stored in a regular table is not private to any session.
A. Can someone explain me when a space allocation occurs?
B. It's not true because GTT are avaible for everyone even without permissions like SELECT.
C. Changing in private session causes only for private data in GTT.
D. Any rows existing at GTT retain after close a session but are not avaible.
E. It can be rolled back, GTT works like a normal table.
F. GTT for everyone LOCAL TEMPORARY TABLE only for a current session.
If what I wrote is not true, please correct me.
A) The space is allocated at the time of the first DML operation.
upvoted 5 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
jm9999
4 months agoTheOracleWasTaken
5 months, 2 weeks agozouve
6 months, 2 weeks agoholdfaststrongly
1 year, 3 months agokarols32
1 year, 4 months agoholdfaststrongly
1 year, 3 months ago