data dictonary

[akhil]

Hi friends,

Is there any table which stores the details of all the data dictonary tables.

Thanks

[khussain]

If you are looking for the desc. of the fields in the DD views, NO, there is no such table.

If you want to find a DD table, and do not remember the exact name, you can search the dba_catalog view:

select * from dba_catalog where table_name like 'V$SYS%';

[edsperez]

you can also try querying the dictionary tables, it gives the name of the data dictionary as well as some comments on the contents of the table.

try; select * from dictionary