What are the main uses of Data Dictionary in Oracle ? Thank you.
asked
What are the uses of Data Dictionary ?
The data dictionary is where the Oracle RDBMS stores the logical and physical structure of the database; e.g. the objects in the database, the structure of your tables, where the datafiles are, which extents are used by which segments, what constraints exist, and so on.
http://download.oracle.com/docs/cd/B28359_01/server.111/b28318/intro.htm#i60808
It's usually queried through the static data dictionary views (DBA_<whatever> and so on) when you need to find out about the logical or physical structure, or the objects in the database.
Oh my gosh. The data dictionary is in my opinion very good to have. Searching for columns, searching for links, displaying information on the various objects you have in the database.
I often use SELECT * from DICT WHERE COMMENTS LIKE '%privilegies%' or something else I want to know more about tables or views in the dictionary.
THere are many goodies there.
