Using Oracle
dbms_rectifier_diff
The
dbms_rectifier_diff
package contains the APIs that can be
used to determine if data inconsistencies
exist between two replicated sites. It can
then be used to resolve those
inconsistencies.
To have Oracle resynchronize the two tables
you next run the dbms_rectifier_diff.rectify
procedure. Oracle will resynchronize the
remote table with the local table. The local
table’s
data will not be changed. Oracle will insert
the missing rows and delete the rows that
are not
contained in the local table.
dbms_rectifier_diff.rectify(
sname1 => 'PUBS',
oname1 => 'AUTHOR',
reference_site => 'NAVDB.WORLD',
sname2 => 'PUBS',
oname2 => 'AUTHOR',
SEE CODE DEPOT FOR FULL SCRIPT
comparison_site => 'MYDB.WORLD',
column_list => NULL,
missing_rows_sname => 'PUBS',
missing_rows_oname1 => 'MISSING_ROWS_AUTHOR',
missing_rows_oname2 => 'MISSING_LOCATION_AUTHOR'
,
missing_rows_site => 'NAVDB.WORLD',
comit_rows => 100);
The last point about the dbms_rectifier_diff
package is that both procedures may take an
extremely long time to execute.
One way to determine if your data is out of
synch is to use the dbms_rectifier_diff
package that
comes with Oracle9i.
The last point about the dbms_rectifier_diff
package is that both procedures may take an
extremely
long time to execute. You might want to just
re-instantiate the remote table using
transportable
tablespaces or an export of the local table
|
|
