Hi,
I have a requirement where table1 exists in 2 diiferent oracle dbs . I need to write a shell script or pl sql block which would compare every column of the table in db 1 and db2 and give following output from unix. It should be able to take any two dbs and any table as input.
Output 1 : primary key is different . Which means so many records are say additional in the table in db2 on top of db1.
Output 2: for all those records in db1 which exist in db2 as well,that is same primary key, but some data in other columns is difference. In this case I need the exact column which has differen e
In both these scenarios, also I would need to convert the out records into insert stts.
Could you please help me with a script for this. I was checking dbms comparison package but I am nt able to see the actual column which has the difference anywhere in the views. Kindly guide
Example.
Table1 has primary key as say "id" and columns as c1 till c 10.
Now in Db1 ' Table1 has 100 records, Id1 to Id100.
In Db2, same table1 has 150'records . 50 additional records with primary key diff. ALSO in Db2, for the existing records from Id1 to Id100, some of the records' data is modified thatis data in any of the columns c1 to c10 are modified.
Now given input as Db1 , Db2 names, Table name as Table1, script should compare entire table data and give output as
Unique records in DB2 (as insert stts for entire record .. all column with values) say in a file, csv or seed sql. Similarly all records with difference with exact column which hs the diff.
Please help me with some sample code.