Compare two identical tables data in different Oracle Databases
Hi Oracle Gurus,
PLease I need immediate attention of someone for this problem. We are testing our application to see whether on 8i DB and 9i DB, the data has posted correctly in all columns of set of tables.
We need to compare every column data in two identical structure tables in too different versions of Oracle Databases.
One crude method I found is to do
"select * from 8i_table
select * from 9i_table"
But as we have more than 60-70 columns and thousands of rows in the table, it is becoming costly and very slow.
What would be the best way to do this? We are in the process of migrating to 9i before that user wanted this test to be done.
Thanks and appreciate your help in advance.
I am just waiting for your expert comments and feedback.
If you know any link to the script developed by you or someone is also fine.