|
Oracle's Data DictionaryDuring the creation of the database, the Oracle Server creates additional physical objects in the datafiles and logical structures within the instance. These structures assist in the running of the database and the location of other structures. These structures include a set of read-only tables and views that record and provide verification and other information about the database to which it belongs. In the data dictionary there are base tables that store the description of the database and its components. These base tables are created behind the scenes automatically when you issue the CREATE DATABASE command (Oracle runs sql.bsq to create them). They are the first structures in any Oracle database. The Oracle Server writes to these tables whenever there is a need to update any of them. It is the only thing that should ever write to these tables; no data definition language (DDL) or data manipulation language (DML) should ever be run to update any of these tables with the exception, possibly, of the AUD$ tables that are connected to auditing.
Also inside the data dictionary are the data dictionary views that summarize and compartmentalize the base table information. These views allow for a more useful and formatted presentation, including object names rather than simply the stored object numbers. These read-only views are created when you run the catalog.sql script located in the $ORACLE_HOME/rdbms/admin (for UNIX) or %ORACLE_HOME%\rdbms\admin (on Windows) directory. Through these tables and views, you can learn more about the definitions and names, definitions and space allocations of objects, and integrity constraints on the various objects. You can learn about users, their roles and privileges, and information about auditing these users' actions. The data dictionary contains the following:
The data dictionary is located in the system tablespace and usually needs to be re-created when you upgrade the database from one version of the server to another. |
|