About Static Data Dictionary Views

Data dictionary tables are not directly accessible, but you can access information in them through data dictionary views. To list the data dictionary views available to you, query the view DICTIONARY.

Many data dictionary tables have three corresponding views:

An ALL_ view displays all the information accessible to the current user, including information from the current user's schema as well as information from objects in other schemas, if the current user has access to those objects by way of grants of privileges or roles.
A DBA_ view displays all relevant information in the entire database. DBA_ views are intended only for administrators. They can be accessed only by users with the SELECT ANY TABLE privilege. This privilege is assigned to the DBA role when the system is initially installed.
A USER_ view displays all the information from the schema of the current user. No special privileges are required to query these views.

The columns of the ALL_, DBA_, and USER_ views corresponding to a single data dictionary table are usually nearly identical. Therefore, these views are described in full only once in this chapter, at their first occurrence alphabetically, and are listed without full descriptions at their other occurrences.

Oracle Replication Views

A number of data dictionary views are relevant only if you are using Oracle Replication. Table 2-1 lists these views.

Table 2-1 Oracle Replication Data Dictionary Views

ALL_ Views	DBA_ Views	USER_ Views
`ALL_REPCAT`	`DBA_REPCAT`	`USER_REPCAT`
	`DBA_REPCAT_EXCEPTIONS`
`ALL_REPCAT_REFRESH_TEMPLATES`	`DBA_REPCAT_REFRESH_TEMPLATES`	`USER_REPCAT_REFRESH_TEMPLATES`
`ALL_REPCAT_TEMPLATE_OBJECTS`	`DBA_REPCAT_TEMPLATE_OBJECTS`	`USER_REPCAT_TEMPLATE_OBJECTS`
`ALL_REPCAT_TEMPLATE_PARMS`	`DBA_REPCAT_TEMPLATE_PARMS`	`USER_REPCAT_TEMPLATE_PARMS`
`ALL_REPCAT_TEMPLATE_SITES`	`DBA_REPCAT_TEMPLATE_SITES`	`USER_REPCAT_TEMPLATE_SITES`
`ALL_REPCAT_USER_AUTHORIZATIONS`	`DBA_REPCAT_USER_AUTHORIZATIONS`	`USER_REPCAT_USER_AUTHORIZATIONS`
`ALL_REPCAT_USER_PARM_VALUES`	`DBA_REPCAT_USER_PARM_VALUES`	`USER_REPCAT_USER_PARM_VALUES`
`ALL_REPCATLOG`	`DBA_REPCATLOG`	`USER_REPCATLOG`
`ALL_REPCOLUMN`	`DBA_REPCOLUMN`	`USER_REPCOLUMN`
`ALL_REPCOLUMN_GROUP`	`DBA_REPCOLUMN_GROUP`	`USER_REPCOLUMN_GROUP`
`ALL_REPCONFLICT`	`DBA_REPCONFLICT`	`USER_REPCONFLICT`
`ALL_REPDDL`	`DBA_REPDDL`	`USER_REPDDL`
	`DBA_REPEXTENSIONS`
`ALL_REPFLAVOR_COLUMNS`	`DBA_REPFLAVOR_COLUMNS`	`USER_REPFLAVOR_COLUMNS`
`ALL_REPFLAVOR_OBJECTS`	`DBA_REPFLAVOR_OBJECTS`	`USER_REPFLAVOR_OBJECTS`
`ALL_REPFLAVORS`	`DBA_REPFLAVORS`	`USER_REPFLAVORS`
`ALL_REPGENERATED`	`DBA_REPGENERATED`	`USER_REPGENERATED`
`ALL_REPGENOBJECTS`	`DBA_REPGENOBJECTS`	`USER_REPGENOBJECTS`
`ALL_REPGROUP`	`DBA_REPGROUP`	`USER_REPGROUP`
`ALL_REPGROUP_PRIVILEGES`	`DBA_REPGROUP_PRIVILEGES`	`USER_REPGROUP_PRIVILEGES`
`ALL_REPGROUPED_COLUMN`	`DBA_REPGROUPED_COLUMN`	`USER_REPGROUPED_COLUMN`
`ALL_REPKEY_COLUMNS`	`DBA_REPKEY_COLUMNS`	`USER_REPKEY_COLUMNS`
`ALL_REPOBJECT`	`DBA_REPOBJECT`	`USER_REPOBJECT`
`ALL_REPPARAMETER_COLUMN`	`DBA_REPPARAMETER_COLUMN`	`USER_REPPARAMETER_COLUMN`
`ALL_REPPRIORITY`	`DBA_REPPRIORITY`	`USER_REPPRIORITY`
`ALL_REPPRIORITY_GROUP`	`DBA_REPPRIORITY_GROUP`	`USER_REPPRIORITY_GROUP`
`ALL_REPPROP`	`DBA_REPPROP`	`USER_REPPROP`
`ALL_REPRESOL_STATS_CONTROL`	`DBA_REPRESOL_STATS_CONTROL`	`USER_REPRESOL_STATS_CONTROL`
`ALL_REPRESOLUTION`	`DBA_REPRESOLUTION`	`USER_REPRESOLUTION`
`ALL_REPRESOLUTION_METHOD`	`DBA_REPRESOLUTION_METHOD`	`USER_REPRESOLUTION_METHOD`
`ALL_REPRESOLUTION_STATISTICS`	`DBA_REPRESOLUTION_STATISTICS`	`USER_REPRESOLUTION_STATISTICS`
`ALL_REPSCHEMA`	`DBA_REPSCHEMA`	`USER_REPSCHEMA`
`ALL_REPSITES`	`DBA_REPSITES`	`USER_REPSITES`
	`DBA_REPSITES_NEW`

The following are additional Oracle Replication data dictionary views:

DEFCALL
DEFCALLDEST
DEFDEFAULTDEST
DEFERRCOUNT
DEFERROR
DEFLOB
DEFPROPAGATOR
DEFSCHEDULE
DEFTRAN
DEFTRANDEST

Oracle Workspace Manager Views

A number of data dictionary views are relevant only if you are using Oracle Workspace Manager. Table 2-2 lists these views.

Table 2-2 Oracle Workspace Manager Data Dictionary Views

ALL_ Views	DBA_ Views	USER_ Views
`ALL_VERSION_HVIEW`
`ALL_WM_LOCKED_TABLES`		`USER_WM_LOCKED_TABLES`
`ALL_WM_MODIFIED_TABLES`		`USER_WM_MODIFIED_TABLES`
		`USER_WM_PRIVS`
`ALL_WM_RIC_INFO`		`USER_WM_RIC_INFO`
`ALL_WM_TAB_TRIGGERS`		`USER_WM_TAB_TRIGGERS`
`ALL_WM_VERSIONED_TABLES`		`USER_WM_VERSIONED_TABLES`
`ALL_WM_VT_ERRORS`		`USER_WM_VT_ERRORS`
`ALL_WORKSPACE_PRIVS`		`USER_WORKSPACE_PRIVS`
`ALL_WORKSPACE_SAVEPOINTS`		`USER_WORKSPACE_SAVEPOINTS`
	`DBA_WORKSPACE_SESSIONS`
`ALL_WORKSPACES`	`DBA_WORKSPACES`	`USER_WORKSPACES`

The following are additional Oracle Workspace Manager data dictionary views:

ROLE_WM_PRIVS
WM_INSTALLATION
WM_REPLICATION_INFO

Recovery Catalog Views

The following data dictionary views are only available after you create an optional recovery catalog (which contains schemas containing information about backups) for use with Recovery Manager:

RC_ARCHIVED_LOG
RC_BACKUP_CONTROLFILE
RC_BACKUP_CORRUPTION
RC_BACKUP_DATAFILE
RC_BACKUP_FILES
RC_BACKUP_PIECE
RC_BACKUP_REDOLOG
RC_BACKUP_SET
RC_BACKUP_SPFILE
RC_CHECKPOINT
RC_CONTROLFILE_COPY
RC_COPY_CORRUPTION
RC_DATABASE
RC_DATABASE_BLOCK_CORRUPTION
RC_DATABASE_INCARNATION
RC_DATAFILE
RC_DATAFILE_COPY
RC_LOG_HISTORY
RC_OFFLINE_RANGE
RC_PROXY_CONTROLFILE
RC_PROXY_DATAFILE
RC_REDO_LOG
RC_REDO_THREAD
RC_RESYNC
RC_RMAN_BACKUP_JOB_DETAILS
RC_RMAN_BACKUP_SUBJOB_DETAILS
RC_RMAN_CONFIGURATION
RC_RMAN_OUTPUT
RC_RMAN_STATUS
RC_STORED_SCRIPT
RC_STORED_SCRIPT_LINE
RC_TABLESPACE
RC_TEMPFILE