Comparing 2 tables for Data Migration
Posted on 2011-03-23
I have a source Environment with source tables
I have a target Environment with Target Tables.
We have written pl/sql package to migrate source tables into target tables
All the fields are not one to one mapping.
So, many queries are written and procedures created and data migration done.
We are in the process of verification of source and target data in our environment.
Using compare script method, we are putting both source and target queries and comparing now. But we are getting out of memory error some times due to larger volume.
So, we want to try to read one row in cursor of source table and one row of the target row
1) Please provide me the best method to verifiy without out of memory error.
2) is it possible to use row type compare both source rowtype and target rowtype
I am getting error while trying to do so.
Please help and guide me on this