DBA

Data Dictionary :-

* During Database creation, The oracle server crerates additional object structures within datafiles.

• Data Dictionary Tables
• Dynamic Performance Tables

Data Dictionary :-

* Set of read only tables and views that record,verify and provide information associated with database.

*Describe databases and its objects

Two types of objects

• Base Tables

--- Store description of database

--- Created with create database

• Data Dictionary Views

--- Summarize base table information

--- Created using catalog.sql script

Base Tables :-

* Base tables are the first objects created in any oracle database.

* They are automatically created when the Oracle server runs the sql.bsq script at the time database is created.

* Users rarely access them directly. because it stored in a cryptic format.

* Example -- IND$ table which contains information about the index in the database.