I’ve got a strong suspicion that the Data Comparison option in OEM is an
interface to invoke the DBMS_COMPARISON package, which does exactly what you
asking for. I’m not sure if any licensing is require for this package
You’ll probably need write scripts to manage it all.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Nagaraj chk
Sent: Tuesday, July 10, 2018 8:59 AM
Subject: Data comparison between two schemas
We would like to know, Data comparison between two schemas are possible via
OEM. I can see an option “Data Comparison” on OEM 13c console, but not sure if
any license is required to test the option. We have a requirement to test the
data integrity between two schemes and do you recommend any option to do in
simpler way ?
**** This communication may contain privileged and/or confidential information.
If you are not the intended recipient, you are hereby notified that disclosing,
copying, or distributing of the contents is strictly prohibited. If you have
received this message in error, please contact the sender immediately and
destroy any copies of this document. ****