View List

[lesstjm]

I read somewhere that there is a view in oracle that you can query to get the name of all the system views in the database. Does anyone know the name of it?

[rohitsn]

Hi,
Run the following query under user SYS to find out all the system views in the database.

select object_name from dba_objects where
owner='SYS' and object_type ='VIEW'

Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
oracle-support@indiatimes.com

[shadow21]

Hi,

You can also run "select * from dict;"
It will show you all the dictionary views and their explanation.

Hope it helps

Cheers

Fabien

[Shestakov]

If u want get full list of dictionary views the :

select VIEW_NAME from sys.V_$FIXED_VIEW_DEFINITION
union
select VIEW_NAME from ALL_VIEWS where owner = 'SYS'
union
select NAME from V$FIXED_TABLE;

[mrvajrala]

Hello ALL,

I do feel difficulty in understanding the some of the colums of the dictionary tables, would anybody help me out in getting the clear description of each column od all dictionary tables, may be in the form of a documnet or any other form...

Thanks ,
Madhu

[marist89]

http://technet.oracle.com/docs/produ...i/content.html

[badrinathn]

This is another link, where you can find explanation for each column

http://technet.oracle.com/docs/produ...76961/ch32.htm

Badrinath