browse: forums | FAQ
Connecting Tech Pros Worldwide
bytes > topic > oracle > answers

Hey there! Do you need Oracle Database help?

Get answers from our community of Oracle Database experts on BYTES! It's free.

Global Temporary Table

sajithamol
Guest
  
Posts: n/a
#1: Jul 11 '07
From which data dictionary table we can get the information of global temporary table?



debasisdas's Avatar
Moderator
  
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,578
#2: Jul 12 '07

re: Global Temporary Table

U can get it from USER_TABLES.

u can use the following query

Expand|Select|Wrap|Line Numbers
  1. select TABLE_NAME from  user_tables where GLOBAL_STATS ='NO';
Reply

« previous question | next question »

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/other

Forums
Visit our community forums for general discussions and latest on Bytes

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 231,098 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

Copyright 1995-2010 BYTES. All rights Reserved About Bytes | Help | Site Map
Bytes Expert Network: 231,098 Members (4324 Online)