Re: How to get a list of tables, indexes, and views in a given schema

Gilles,

Many thanks for the input, I will try this out!

dm.

"Gilles Mercier" <gilles.mercier_at_urbanet.ch> wrote in message news:<3e2a7be6$1_at_news.swissonline.ch>...
> Hi Dom,
> You can do the following :
>
> 1. connect to the DB as the user of the schema you want to ask and query the
> following views :
> - user_tables
> - user_indexes
> - user_triggers
> - user_views
> OR
> 2. connect to the DB as another user who has the DBA rights an query the
> following views :
> - all_tables ( or dba_tables)
> - all_indexes (or dba_indexes)
> - all_triggers (or dba_triggers)
> - all_views (or dba_views)
> adding clause "where owner like 'SCHEMA NAME'
>
> hope this helps,
> Regards
> Gilles
>
>
> "dom" <dominic.morris_at_eidosnet.co.uk> a écrit dans le message de 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 Sun Jan 19 2003 - 20:49:41 CET