Global Temporary Table

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sajithamol
    #1

    Global Temporary Table

    From which data dictionary table we can get the information of global temporary table?
    Tags: None
    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119
      #2
      U can get it from USER_TABLES.

      u can use the following query

      [CODE=oracle]select TABLE_NAME from user_tables where GLOBAL_STATS ='NO';[/CODE]

        Comment

        Previous template Next
        Working...