How to compare data without Veridata
edited Oct 22, 2013 6:19PM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered
We have license for Oracle GoldenGate but do not have it for Veridata. The 10g db is about 2TB and is getting replicated to 11g db. Since we do not have Veridata, is there a quick/simple way to compare the tables?
I have created a db link between these two tables but the problem is with the tables that have millions of rows (query never responds) and if there are large objects (LOBS), then it will not work over db links.
At this point, the only option I have is to check the counts, but that does not a foolproof solution. I need to compare each column between these two databases.
I have created a db link between these two tables but the problem is with the tables that have millions of rows (query never responds) and if there are large objects (LOBS), then it will not work over db links.
At this point, the only option I have is to check the counts, but that does not a foolproof solution. I need to compare each column between these two databases.
0