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

From: David Stark <stark_at_greenwich.com>
Date: 1996/05/01
Message-ID: <1996May1.150539.10459_at_greenwich.com>#1/1

In article <4m3c3q$j8a_at_news2.cais.com> duffy_at_cais.cais.com (MCC) writes:
>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.

get Oracle 7 Server Administrator's Guide
go appendix b and look for the dba_tables table definition.
login to pl/sql and select the fields you wnat from the table.

-- 
David Stark          	  * Opinions expressed in this post are those of
stark_at_greenwich.com 	  * the author and do not in any way represent
Greenwich Associates      * an official statement by Greenwich Associates.
Greenwich CT  06831-5195  *

Received on Wed May 01 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: E. Sedney: "Re: [Q] How to duplicat all data from one DB to another DB"
Previous message: raiden: "Re: [Q] How to list all the tables in DB??"
Maybe in reply to: raiden: "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