Re: Get all table names in a database

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 14 Jan 2000 12:45:28 +0100
Message-ID: <947850427.29362.0.pluto.d4ee154e@news.demon.nl>

Sorry to contradict you.
All_tables shows all the tables the current use has access to/ privilege on. dba_tables shows ALL tables in the database.

Best regards,

--
Sybrand Bakker, Oracle DBA
Violin <violin.hsiao_at_mail.pouchen.com.tw> wrote in message news:387ea3ad.12965713_at_172.16.7.5...
> On Thu, 13 Jan 2000 20:36:59 -0500, "Legend" <legend_at_spacelab.net> wrote:
>
> select owner,table_name from all_tables;
>
>
> >Hello all,
> >
> >How would I get all the table names available in a database within
sqlplus a
> >session?
> >
> >regards,
> >
> >benny
> >
> >
>
Received on Fri Jan 14 2000 - 05:45:28 CST