Re: Get all table names in a database

Do this....If you have logged on with DBA privs

SELECT table_name FROM dba_tables WHERE owner = 'put_the_owners_name_here';

If you want every table leave the WHERE clause out. If you have logged on as the owner do this

SELECT table_name FROM user_tables;

Regards
Peter Winters
Cairns, Queensland, AUSTRALIA.

Legend <legend_at_spacelab.net> wrote in message news:U4vf4.27034$W2.374031_at_iad-read.news.verio.net...
> Hello all,
>
> How would I get all the table names available in a database within sqlplus
a
> session?
>
> regards,
>
> benny
>
>
>
Received on Thu Jan 13 2000 - 20:24:33 CST