Accessing the Data Dictionary

Previous

Next

---

Each Oracle database has a data dictionary. An Oracle data dictionary is a set of tables and views that are used as a read-only reference about the database. For example, a data dictionary stores information about both the logical and physical structure of the database. A data dictionary also stores information about valid Oracle database users, integrity constraints for tables in the database, and the amount of space allocated for a schema object as well as how much of it is being used.

To browse the data dictionary:

1. On the Database Home Page, click the Utilities icon.

2. Click Object Reports and then Data Dictionary.

   The Data Dictionary appears, listing all the Oracle Data Dictionary views.

3. To filter the report, enter a query in the Search field and click Go.

   You can query for details about database objects in the Data Dictionary.

4. Click the View icon to display Data Dictionary Browser.

   The Data Dictionary Browser appears. Use this page to query the Oracle Data Dictionary for details about database objects.

5. On the Data Dictionary Browser page, select the appropriate views and click Query. To select all views, select Check All and then click Query.

   A report appears.

6. To create a new query, click New Query and repeat step 5.

7. To browse another view, click Browse Another View and repeat steps 4 and 5.