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

On Tue, 21 Mar 1995, Chung Hoi Shan wrote:

> Hi,
>
> How can I list all the tables belong to a particular user?
>
> Any help would be appreciated.

if logged in as that user:

select table_name from user_tables;

if logged in as system user:

select table_name from dba_tables

   where owner='USERNAME';

other related tables:

user_indexes
user_views

dba_views
dba_tablespaces
dba_objects

See system admin manual....

Hope this helps!

Guerry                          |    My thoughts are not my company's