DBMS_RECTIFIER_DIFF: Comparing Replicated Tables
If you are not sure whether the data at two sites are identical, you can use the DBMS_RECTIFIER_DIFF package to find out.
How the Package Is Used
The DBMS_RECTIFIER_DIFF’s DIFFERENCES procedure compares two instantiations of a table. The table at one of two sites is considered the reference, or “truth” table, and the other is the “comparison” table. The procedure stores discrepancies between the truth table and comparison table in a “missing rows” table, which the user must create. If differences exist, the DBA can use the RECTIFY procedure to synchronize the comparison table with the truth table. The truth table is not modified.
Installation and Access
The DBMS_RECTIFIER_DIFF package iscreated when the Oracle database is installed. The
dbmsrepc.sql
script (found in the built-in packages source
directory) contains the source code for this package’s
specification. This script is called by
catrep.sql
, which must be run to install the
advanced replication packages. The wrapped SQL script
prvtrctf.sql
creates the public synonym DBMS_RECTIFIER_DIFF. No
EXECUTE privileges are granted on DBMS_RECTIFIER_DIFF; only
the owner (SYS) and those with the EXECUTE ANY PROCEDURE system
privilege may execute the package.
DBMS_RECTIFIER_DIFF Procedures
Procedure Name | Description |
---|---|
DIFFERENCES | Determines differences between the truth table and the comparison table |
RECTIFY | Synchronizes the comparison table with the truth table |
DBMS_RECTIFIER_DIFF Exceptions
Exception ... |
---|
Get Oracle Distributed Systems 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.