Dbvisit Replicate Dictionary Tables

Owned by Copy Space for Confluence
Jan 22, 2017

Usually, there is no need to directly access most of the tables. Nevertheless, some of the tables maybe useful:

Table nameDescription
DBRSAPPLY_CONFLICT_LOG
List of conflicts encountered, including failing SQL.
DBRSAPPLY_CONFLICT_HANDLERS
Conflict handler settings. Note that the key is object id on source database.
DBRSAPPLY
Includes last commit SCN (current_scn), so it can be used to monitor apply progress if SNMP or log monitoring is not an option.
DBRSCOMMON_HEARTBEATDbvisit Replicate Heartbeat table. This table can be used by customer that want to query a table directly to get the current status of replication.