Re: Oracle 6 Table Universe?

From: Mahesh Vallampati <m0v5533_at_tamsun.tamu.edu>
Date: 13 Apr 1994 23:19:49 -0500
Message-ID: <2oig95$8q2_at_tamsun.tamu.edu>

In article <2oem0s$94j_at_fido.asd.sgi.com>, Keith Rich <kxr_at_sierra.corp.sgi.com> wrote:
>
>I'm trying to debug a problem with an application that uses Oracle 6.
>I'd like to print out a bunch of my tables but I don't know the names
>of the tables. I think I should be able to do something like:
>
> select * from system.tables;

                           ^^^^^

Try select * from system.tab;
U could try system.tab to print the list of tables which u have.But if u want to print the contents of the tables in that table of tables u need to do the following
spool the contents of the tables of tables to a file and write an awk or a perl script which will generate the select statements from that file and run them. This should do the trick.
>
>However, the tables of tables is probably called master_catalogue or
>some such thing. I need to be able to do this from the sqldba tool
>because I don't have any of the modern front-end tools.
>
>Can anyone help me by telling what the name of the master table is?
>
>Keith Rich (kxr_at_sierra.corp.sgi.com)

Thanks and Regards
Mahesh Vallampati
M.S. In EE
Dept.of Electrical Engineering,
Texas A & M University.
Ph:(409)845-6189
\\ In the Beginning there was Codd..... Received on Thu Apr 14 1994 - 06:19:49 CEST