Global Temporary tables (GTT) -1. When they are created, its definition goes into Data Dictionary.2. When materialized data goes in temp space.3. thats why, data is active upto the session ends, and definition will remain there upto its not dropped using Drop table statement.If dropped from some other session then its should be Drop table all;4. you can collect stats on GTT.Volatile Temporary tables...

Bikhayat kumar

• Feb 10th, 2014

GTT takes up space from temporary space where as VTT takes up space from spool. GTT survive TD system restarts where as VTT does not. GTT allows index to be created where as VTT does not. In a sing...

Prashant Nile

• Dec 13th, 2013

GTT uses the Temp Space where as Volatile table use the Spool Space. Both are Session Based once you logged of Data gets vanished. For GTT Definitions remains as it is, as it gets stored in Data Di...

Answer Question  Select Best Answer