Re: Oracle simple task

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 21 Sep 2001 06:08:21 +0200
Message-ID: <tqlg3iglkegl96@news.demon.nl>

"WKC" <wkchen_at_bigfoot.com> wrote in message news:zWxq7.33695$n5.4155715_at_typhoon.nyc.rr.com...
> I'm having trouble listing out all tables in oracle using this sql..
>
> select * from v$database
>
> can anyone suggest any other way to list out all the table in a schema in
> using sqlplus?
>
> thanks..
>
>
>

Your sql-statement is incorrect.
Please refer to dba_tables
and issue
select * from dba_tables where owner = '<schemaname>' v$database will list the name of the database only.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Thu Sep 20 2001 - 23:08:21 CDT