Compare Schemas or Tables ?

In Oracle 11g ,  a new package called DBMS_COMPARISON  lets  you compare data between  2 objects.  So now , you don’t have to write and test your home grown scripts.  DBMS_COMPARISON is provided mainly to detect or monitor data inconsistencies between database objects in  streams or GoldenGate. environment  This package lets you compare and converge data   for tables , materialized views , table synonyms and views (single table view only).

Once the comparison of database object is complete, you can get data inconsistencies report from data dictionary views like  DBA_COMPARISON, DBA_COMPARISON_COLUMNS,DBA_COMPARISON_SCAN, DBA_COMPARISON_SCAN_SUMMARY, DBA_COMPARISON_SCAN_VALUES and DBA_COMPARISON_ROW_DIF

Refer to Oracle Documentation for more information :

Tagged: , , , , ,

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: