Oracle DBMS_RECTIFIER_DIFF_INTERNAL
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
Purpose Internal support for DBMS_RECTIFIER_DIFF
AUTHID DEFINER
Dependencies
DBMS_ASSERT DBMS_REPCAT_DECL DBMS_STANDARD
DBMS_DB_VERSION DBMS_REPCAT_SQL_UTL DBMS_SYS_ERROR
DBMS_LOGREP_UTIL DBMS_REPCAT_UTL DBMS_SYS_SQL
DBMS_RECTIFIER_DIFF DBMS_REPUTIL DBMS_UTILITY
DBMS_RECTIFIER_FRIENDS DBMS_SQL SYS_STUB_FOR_PURITY_ANALYSIS
DBMS_REPCAT    
Documented No
First Available 12.1.0.2: The package was present in 11gR2, dropped in 12.1.0.1, and recreated in the current version.
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtrctf.plg
Subprograms
 
DIFFERENCES
  dbms_rectifier_diff_internal.differences (
sname1              VARCHAR2,
oname1              VARCHAR2,
reference_site      VARCHAR2 := '',
sname2              VARCHAR2,
oname2              VARCHAR2,
comparison_site     VARCHAR2 := '',
where_clause        VARCHAR2 := '',
column_list         VARCHAR2 := '',
missing_rows_sname  VARCHAR2,
missing_rows_oname1 VARCHAR2,
missing_rows_oname2 VARCHAR2,
missing_rows_site   VARCHAR2 := '',
max_missing         NUMBER,
commit_rows         NUMBER := 500);
See corresponding DBMS_RECTIFIER_DIFF demo using link below.
Overload 2 dbms_rectifier_diff_internal.differences (
sname1              VARCHAR2,
oname1              VARCHAR2,
reference_site      VARCHAR2 := '',
sname2              VARCHAR2,
oname2              VARCHAR2,
comparison_site     VARCHAR2 := '',
where_clause        VARCHAR2 := '',
array_columns       dbms_utility.name_array,
missing_rows_sname  VARCHAR2,
missing_rows_oname1 VARCHAR2,
missing_rows_oname2 VARCHAR2,
missing_rows_site   VARCHAR2 := '',
max_missing         NUMBER,
commit_rows         NUMBER   := 500);
TBD
 
RECTIFY
  dbms_rectifier_diff_internal.rectify (
sname1              VARCHAR2,
oname1              VARCHAR2,
reference_site      VARCHAR2 := '',
sname2              VARCHAR2,
oname2              VARCHAR2,
comparison_site     VARCHAR2 := '',
column_list         VARCHAR2 := '',
missing_rows_sname  VARCHAR2,
missing_rows_oname1 VARCHAR2,
missing_rows_oname2 VARCHAR2,
missing_rows_site   VARCHAR2 := '',
commit_rows         NUMBER   := 500);
See corresponding DBMS_RECTIFIER_DIFF demo using link below.
Overload 2 dbms_rectifier_diff_internal.rectify (
sname1              VARCHAR2,
oname1              VARCHAR2,
reference_site      VARCHAR2 := '',
sname2              VARCHAR2,
oname2              VARCHAR2,
comparison_site     VARCHAR2 := '',
array_columns       dbms_utility.name_array,
missing_rows_sname  VARCHAR2,
missing_rows_oname1 VARCHAR2,
missing_rows_oname2 VARCHAR2,
missing_rows_site   VARCHAR2 := '',
commit_rows         NUMBER   := 500);
TBD
 
TURN_REPLICATION_OFF
Stop rectification dbms_rectifier_diff.turn_replication_off;
exec dbms_rectifier_diff.turn_replication_off;
 
TURN_REPLICATION_ON
Start rectification dbms_rectifier_diff.turn_replication_on;
exec dbms_rectifier_diff.turn_replication_on;

Related Topics
DBMS_RECTIFIER_DIFF
DBMS_RECTIFIER_FRIENDS
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved