DBMS_COMPARISON
The DBMS_COMPARISON package makes it easy to identify row differences between tables, single-table views, materialized views and synonyms to the previous object types, and optionally converge the data. The documentation includes security information , operational notes , indexing requirements and a number of restrictions associated with this functionality, which you can read here . In this article we will keep things simple and just do a basic comparison between two tables. Setup Create a New Comparison Run the Comparison Check the Results of the Comparison Recheck the Comparison Converge the Data in the Objects (Optional) Purge a Comparison Drop a Comparison Trigger Timing Points Setup Create two test users. CONN / AS SYSDBA DROP USER local_user CASCADE; DROP USER remote_user CASCADE; CREATE USER local_user IDENTIFIED BY local_user QUOTA UNLIMITED ON users; GRANT CREATE SESS...