Re: [Q] How to list all the tables in DB??

From: Chuck Isaacson <ccisaac_at_mtu.edu>
Date: 1996/04/29
Message-ID: <4m3r0a$6er_at_ctsad4.cts>#1/1


If you have dba access the info you want is in the dba_tables table. If you do not have dba privilege look in all_tables, this will give you the info on tables you do have access to. The third part of this is user_tables, these are tables that you own.

HTH MCC (duffy_at_cais.cais.com) wrote:
: We have Oacle 7.2.3 installed on SUN Solaris 2.5. Can anyone tell me how
: to list all the tables in DB? the list should include table name,
: tablespace name, owner info. Thank you for help.
Received on Mon Apr 29 1996 - 00:00:00 CEST

Original text of this message