Re: I don't know what tables are contained in a database

Log in as system and select owner, table_name from dba_tables.

No matter who you log in as, you can also select owner, table_name from all_tables or select table_name from user_tables to show you all tables accessible to you or just the ones you own, respectively.

hth.

Yosi

james wrote:

> Hi all,
>
> In sqlplus ,how can I know what tables are contained in a database
>
> and which privileges should be granted for the preceding activity.
>
> Thanks in advance
>
> James
Received on Wed Nov 03 1999 - 08:59:35 CST