Oracle: DBMS_COMPARISON package
An interesting feature for Oracle 11g is DBMS_COMPARISON package which planned to use compare data within two schemas or between database`s schema. To use DBMS_COMPARISON you have to grant. If you connected as SYSDBA you already have had grant to execute. Other users need execute grants on DBMS_COMPARISON and that user will need to be granted execute catalog role too. Note: The database character sets must be the same for the databases that contain the database objects being compared. For all scan modes to be supported by the DBMS_COMPARISON package, the database objects must have one of the following types...