Oracle Data Dictionary


The Oracle data dictionary is generally made up of a dictionary of tables and indexes along with various Oracle-provided packages, procedures and functions.

These Data Dictionary web pages will attempt to explain the following. Included will be the Oracle database data dictionary plus the Oracle provided packages, procedures and functions.

The data dictionary is the data about the data. Data about data is called Metadata. The Metadata is the data which describes the data. The data dictionary contains the definitions of tables. The tables are where actual data is added to. Metadata is the details containing data types, lengths,precisions and which data items are contained within which objects. All details of tables, indexes, synonyms, views, grants, roles, etc. are contained within the data dictionary.