Re: How to get a list of tables, indexes, and views in a given schema
Date: Wed, 22 Jan 2003 10:47:52 -0600
Message-ID: <b0mi22$unu$1_at_gabriel.uhc.com>
Maybe this has already been covered, but you could use the free GUI tool called TOAD or DbVisualizer.
"dom" <dominic.morris_at_eidosnet.co.uk> wrote in message
news:c5c9bfea.0301190202.7fe6b8d6_at_posting.google.com...
> <newbie>
> Hi all,
>
> Following on from my question regarding how to get a list of schemas
> in a given Oracle DB, I'd like to now know which sys table(s) to query
> for a list of:
>
> 1) tables
> 2) indexes
> 3) views
>
> within a given Oracle schema. I guess you can see where I'm going with
> this...! For each view I'd like to get the text of the view, for each
> index, the participtating columns, for each table, the columns & their
> datatypes, sizes, defaults, nullability, etc., triggers & texts.
>
> Many thanks for any advice.
> dm.
> </newbie>
Received on Wed Jan 22 2003 - 17:47:52 CET