hi,

I just want to know whether there is any site or help available that gives with example for dict. I mean in sqlplus when we type select * from dict. The tablename displayed with comments is not enough to understand.

So I am looking for a site that gives in depth or in detail about dict and when and how to use them.

Thanks in advance.

Have you tried the Oracle website?

THe data dictionary is a vast thing to mess around with.. generally there are a number of tables you'll find useful,
user_indexes,
user_tables,
user_objects,
(then replace user with all_etc)
A good source would be Oracle DBA books by Osborne (publishers), they're expensive so join the local library.
I'm afraid it took me the best part of a degree to work out how to use Oracle and the Data Dictionary effectively so be prepared to spend some time on this one!!

Simon



Don't think, do!