Re: Data Dictionary

I don't know of anyplace that defines all those views but you can certainly find out yourself by logging into Oracle as the sys user.

The user_ data dictionary views are just views on dba_ where owner = (whoever you are logged in as). The dba_ views are readily available from any user that has dba privilege. For a listing of all of them, try this...

select view_name from dba_views where owner = 'SYS' and view_name like 'DBA%'

similiarly you can get a listing of the all_ views. All_ views show what objects, tables, etc. that the user in question has access to.

HTH RHC Nick G. Anagnos wrote:
>
> Was wondering if anyone knows of a site where I can download a listing
> of all_* , dba_*, and user_* data dictionary views. Interested in
> the view stucture and column meanings.
>
> Nick G. Anagnos
>

--
Posted via CNET Help.com
http://www.help.com/