OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » All Table

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

All Table [message #372647]

Thu, 01 March 2001 16:55

Ralphie
Messages: 14
Registered: October 2000

Junior Member

In SQL Plus is there a way to see all the tables in one users Schema?

Thank you in advance,

Chris

Report message to a moderator

Re: All Table [message #372649 is a reply to message #372647]

Thu, 01 March 2001 23:41

ramu
Messages: 82
Registered: February 2001

Member

There are many ways to select the schema objects..

1. select t_name from tab where tabtype='TABLE';

2. select table_name from tabs;

3. select object_name from user_objects;

4. select object_name from all_objects where owner='&owner';

5. select table_name from user_tables;

6. select table_name from all_tables where
owner='&owner';

Thanks..
Ramu.

Report message to a moderator

Re: All Table [message #372659 is a reply to message #372647]

Fri, 02 March 2001 09:46

Ralphie
Messages: 14
Registered: October 2000

Junior Member

This is helpful, but i am unable to use these commands in SQL. Can you help me with what the object_name, table_name, user_tables, t_name, tab, tabtype and all_objects represent? I'm unable to use these from SQL Plus and I'm not very familiar with Oracle views or system objects.

Thank you for your help,

Chris

Report message to a moderator