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. ...
Get Oracle in a Nutshell 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.
