Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: All tables
hello Madhivanan,
select * from global_name;
select * from ALL_TABLES ; (select * from DBA_TABLES is for System only )
-- Met vriendelijke groeten Roelof Schierbeek; DBA "Madhivanan" <madhivanan2001_at_gmail.com> schreef in bericht ...Received on Fri May 06 2005 - 08:28:13 CDT
> 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