Re: To list all tables of a particular user??

Chung Hoi Shan (cs_henry_at_ug.cs.ust.hk) wrote: : Hi,  

: How can I list all the tables belong to a particular user?  

: Any help would be appreciated.
: Henry (cs_henry_at_cs.ust.hk)

--
If you are logged into Oracle as the user in question:

SQLPLUS > select table_name from user_tables;

If you are logged into Oracle as a DBA:

SQLPLUS > select table_name from system.dba_tables


        > where owner = 'username in question';



If you are logged into Oracle as a user who has access to all tables:

SQLPLUS > select table_name from all_tables


        > where owner = 'username in question';



Hope this helps

Murray Kaiser                  | Usual gutless disclaimer..
Nova Scotia Power              | Opinions are mine and not necessarily
(Murray.Kaiser_at_NSPower.NS.CA)  | shared by my employer