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

This message: [ Message body ]
Next message: Harshan Ramarathnam: "Re: [Q] How to duplicat all data from one DB to another DB"
In reply to MCC: "[Q] How to list all the tables in DB??"
Next in thread: R. Schierbeek: "Re: [Q] How to list all the tables in DB??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message