Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: All tables

Re: All tables

From: R.S. <bytelife_at_gmail.com>
Date: Fri, 6 May 2005 15:28:13 +0200
Message-ID: <427b70e1$0$5703$dbd43001@news.wanadoo.nl>


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  ...

> 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
Received on Fri May 06 2005 - 08:28:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US