OraFAQ Forum: Server Administration » How to Find the Temporary Tables

Home » RDBMS Server » Server Administration » How to Find the Temporary Tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Find the Temporary Tables [message #221738]

Wed, 28 February 2007 04:30

irfanr
Messages: 11
Registered: December 2006
Location: india

Junior Member

Hello,

How to find the Temporary tables in one schema and then entire database.

Thanks

Report message to a moderator

Re: How to Find the Temporary Tables [message #221742 is a reply to message #221738]

Wed, 28 February 2007 04:40

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You mean GTT?
Just check user_tables/dba_tables

SCOTT > create table x (c1 number);

Table created.

SCOTT > create global temporary table gtt (c1 number);

Table created.

SCOTT > select table_name,temporary from user_tables;

TABLE_NAME                     T
------------------------------ -
X                              N
GTT                            Y

[Updated on: Wed, 28 February 2007 04:40]

Report message to a moderator

Re: How to Find the Temporary Tables [message #222129 is a reply to message #221738]

Fri, 02 March 2007 00:06

irfanr
Messages: 11
Registered: December 2006
Location: india

Junior Member

Hi,

thank you very much.

Regards

Report message to a moderator

Previous Topic:	performance tuning redo logs
Next Topic:	performance tuning redo logs (10g standard)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 09:19:09 CST 2024