Re: All tables

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 6 May 2005 09:30:15 -0400
Message-ID: <ls2dndoZSpv07ObfRVn-pA@comcast.com>

"Madhivanan" <madhivanan2001_at_gmail.com> wrote in message news:1115385518.506945.129360_at_f14g2000cwb.googlegroups.com...
> Rauf,
> select name from v$database;
> gives the error
>
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> Chris,
>
> SELECT * FROM DBA_TABLES
>
> gives the error
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> Madhivanan
>

you are using an account that does not have DBA privileges (such as SELECT_CATALOG_ROLE), so these views are not available to you.

the user SYSTEM is the default DBA user

the other answer provided should work for any account (select * from global_name, select * from all_tables) however, ALL_TABLES will only show tables that the account has access to, not all tables in the database.

you will also need to look at other data dictionary views to get a listing of objects besides tables, such as ALL_VIEWS and ALL_OBJECTS

++ mcs Received on Fri May 06 2005 - 08:30:15 CDT