Replication
The following views provide information used by Oracle’s advanced replication facilities. Oracle currently recommends using the Replication Manager to obtain the information in these views:
- *_ANALYZE_OBJECTS
Lists analyze objects. Obsolete with Oracle9i.
- *_REGISTERED_SNAPSHOT_GROUPS, _REGISTERED_MVIEW_GROUPS
Lists registered snapshot groups.
- *_REPAUDIT_ATTRIBUTE
Lists replication audit attributes.
- *_REPAUDIT_COLUMN
Lists replication audit columns.
- *_REPCAT
Lists the interim status of any asynchronous administrative requests and any error messages generated.
- *_REPCATLOG
Lists the interim status of any asynchronous administrative requests and any error messages generated.
- *_REPCOLUMN
Lists replicated columns for a group.
- *_REPCOLUMN_GROUP
Lists column groups defined for a table. There is no USER_REPCOLUMN_GROUP view.
- *_REPCONFLICT
Lists tables with replication conflict resolution methods and the methods for the tables. There is no USER_ALL_REPCONFLICT view.
- *_REPDDL
Lists DDL for replication objects.
- *_REPGENOBJECTS
Lists objects generated to support replication.
- *_REPGROUP
Lists users who are registered for object group privileges.
- *_REPGROUPED_COLUMN
Lists columns in column groups for each table.
- *_REPKEY_COLUMNS
Lists information about primary key columns for replicated tables.
- *_REPOBJECT
Lists objects in each replicated object group.
- *_REPPARAMETER_COLUMN
Lists information about columns used to resolve conflicts.
- *_REPPRIORITY
Lists value and priority level of each priority group. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access