Re: how to list all tables in sqlplus

[Quoted] 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:

[Quoted] [Quoted] Where are these user_tables, all_tables, dba_tables, and dba_objects created? [Quoted] My machine does have the user_talbes and all_tables but does not have [Quoted] 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
  Received on Thu Nov 23 2000 - 23:10:30 CET