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_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