Re: sho command

From: joel garry <>
Date: Thu, 3 Jan 2008 10:38:42 -0800 (PST)
Message-ID: <>

On Jan 2, 10:29 pm, Rosie <> wrote:
> On Dec 31 2007, 5:36 pm, Rosie <> wrote:
> > Using Oracle 9i -
> > Using PL/SQL
> > Is there a command like SQL's show table command that will show all
> > the information for a specific table, like the table columns & size,
> > any views, indexes, procedures, constraints, triggers, etc. associated
> > with the table?
> > Also, is there a command to show the dependancies associated to a
> > table?
> > Thanks,
> THANK YOU to eveyone for the info provided. To give more info, I am
> new to Oracle (learning by books) and need to do a print out of each
> schema by table that includes any indexes, views, procedures,
> triggers, dependencies, etc. associated with the table and all the
> attributes of each.
> In Oracle RDB using SQL, you can type the command show table
> table_name and everything created for that table appears - indexes,
> views, triggers, etc. I was hoping there was a command for Oracle
> using PL/SQL that would do the same thing.
> Currently, I am using OEM to generate the printouts but was hoping
> there was something else available (less time consuming).
> So, if I am understanding correctly, the alternative in getting what I
> am looking for -- the table plus it's indexes, triggers, etc. would
> need to be done programmatically through the information Mark & Mladen
> provided gathering the information from multiple table views specified
> in the dictionary.
> Any additional assistance is greatly appreciated.

You can also use the exp utility to generate lots of what you want. Simply use the rows=n full=y command on the export, then show=y command on import, to get a file of many interesting things. This is in the utility manual in the docs, see . If you are on unix, you can also run the strings command on the file created by exp to spit things out directly.

To really learn Oracle administration, you should get familiar with using the standard stored procedures.

Here is a bit of newbie information about posting here:


-- is bogus.
Received on Thu Jan 03 2008 - 12:38:42 CST

Original text of this message