Oracle simple task

From: Kock, Gerd <GKock_at_pdv-Online.de>
Date: Fri, 21 Sep 2001 07:35:11 +0200
Message-ID: <90333AAED533D411950600104B45E0190377B85C@pdv-exchng.pdv-online.de>

select *
from user_tables;

---

user_tables: your own tables
user_views
user_objects

...

all_tables: all tables you have access to
all_views
all_objects

...

dba_tables: all tables in database (if you're allowed to select this)
dba_views
dba_objects

...

Gerd Kock
Oracle DBA

-----Ursprüngliche Nachricht-----
Von: WKC [mailto:wkchen_at_bigfoot.com]
Bereitgestellt: Freitag, 21. September 2001 04:51 Bereitgestellt in: server
Unterhaltung: Oracle simple task
Betreff: Oracle simple task

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.. Received on Fri Sep 21 2001 - 00:35:11 CDT