Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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:

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

See Also:

Oracle Database Advanced Replication Management API Reference for information about these views

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.

The following are additional Oracle Workspace Manager data dictionary views:


ROLE_WM_PRIVS
WM_INSTALLATION
WM_REPLICATION_INFO

See Also:

Oracle Database Application Developer's Guide - Workspace Manager for information about these views

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

See Also:

Oracle Database Backup and Recovery Reference for information about these views