Another interesting feature for Oracle 11g is DBMS_COMPARISON package which planned to use compare data within two schemas or between database`s schema. You can use this package for several reason: if replication/streams broken, or checking between production and test databases data etc. 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 of indexes: · A single-column index on a number, timestamp, interval, or DATE datatype column · ...