Go Back   Site Owners Forums - Webmaster Forums > General Arena > General Discussion

Notices


Reply
 
Thread Tools Rate Thread Display Modes
Old 06-22-2018, 01:06 AM   #1
ashabansal
Registered User
 
Join Date: Sep 2017
Posts: 33
Post Global Temporary Tables

(Oracle 8i) is considered to be vital for DBAs and developers.
What are Global Temporary Tables:
Data in this table is stored as long as the session or transaction gets over and is private for each session. eventually, after disconnection, the data is lost but the definition of the table remains. Performing ddl operations is not necessary, however.
The synonyms, or views and other structures related to the temporary table don’t disappear after transaction or session. Indexes will be created likewise. The features of Temporary tables have triggers and all the statistics related to table access cost, information of rows and blocks, join cardinality, etc. Foreign keys cannot be integrated into temporary tables.
Examples of usage involves replicated data manipulation from remote tables, it is also useful in temporarily storing a set of rows to be processed against other tables.
There is no denying that Oracle database has evolved over the years. Some redundant features have paved way for ingenious additions to which Oracle Global Temporary Tables (GTT) is one of the latest.
To read more on Global Temporary table in Oracle, read here: https://www.edupristine.com/blog/ora...mporary-tables
ashabansal is offline   Reply With Quote

Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 02:07 AM.


Powered by vBulletin Copyright © 2020 vBulletin Solutions, Inc.