The Data Dictionary: A Unique Schema

Every Oracle database uses a number of system tables and views to keep track of metadata—data about the data in a database. This collection of system objects is called the Oracle database's data dictionary or system catalog. Oracle organizes a database's data dictionary within the SYS schema.

Categories of Data Dictionary Views

Oracle's data dictionary contains several different categories of data dictionary views:

ImageViews with the prefix DBA_ Present all information in the corresponding data dictionary base tables. Because the DBA views are comprehensive, they are accessible only to users that have been granted ...

Get Hands-On Oracle Database 10g Express Edition for Windows now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.