Re: how to list all tables in sqlplus

"Steve" <sfang88_at_yahoo.com> wrote in message news:3A1D95D6.788A44EB_at_yahoo.com...
> It turned out that this works:
>
> SQL>select table_name from all_tables;
>
> or
> SQL>select table_name from user_tables;
>
> Your recommended way does not work on my machine. So now comes that
 question:
>
> Where are these user_tables, all_tables, dba_tables, and dba_objects
 created?
> My machine does have the user_talbes and all_tables but does not have
> dba_tables and dba_objects. Why? I was logged in as DBA/DBO.
>
> Thanks!
>
> Steve
>
> "Matt B." wrote:
>
> > "Steve" <sfang88_at_yahoo.com> wrote in message
> > news:3A1D583E.ECDB6F05_at_yahoo.com...
> > > I tried "select table_name from dba_tables" but it says there is no
 table
> > > "dba_tables". What could other name be? Thanks Matt!
> > >
> > > Steve
> >
> > No? Dang! That's weird. Maybe my brain is failing...
> >
> > Try this:
> >
> > select object_name
> > from dba_objects
> > where object_type = 'TABLE';
> >
> > -Matt
>

Are you sure you were running with the correct privileges. These views (user*, all* AND dba*) are created in one single script, catalog.sql in $ORACLE_HOME/rdbms/admin

Regards,

Sybrand Bakker, Oracle DBA Received on Thu Nov 23 2000 - 23:44:55 CET