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

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'

"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 - 11:20:22 CET