Re: How do I list all existing databases and tables ?

Kuo,

You need to connect to system/manager if you're just a user, then use

select table_name from dba_tables
to find table names

(W/O connecting to system use select * from user_catalog)

checkout other dba tables for more info about tablespace, objects, clusters, etc. (dba_tablespaces, dba_objects)

Hope this helps,

-Patti

SDSC Consulting
pattimcc_at_sdsc.edu

>
> For Sybase,
> 'select name from master..sysdatabases'
> will list all existing databases.
>
> 'select name from sysobjects where type='U''
> will list all existing user tables.
>
> What are the equivalent commands for Oracle ?
> ---
> Best Regards,
>
> Kuo-Chien Kai
> ----------------------------------------------------------------
> Computer & Communication Center | E-mail: kckai_at_cc.nthu.edu.tw
> National Tsing Hua University | Phone: +886-35-715131-5160
> Hsinchu, Taiwan 30043 | Fax: +886-35-710776
  Received on Fri May 03 1996 - 00:00:00 CEST