Re: Q: Comparing two tables in Oracle

In article <3npfb4$mki_at_oznet03.ozemail.com.au> npbs_at_ozemail.com.au (Newcastle Permanent Building Society) writes:
>From: npbs_at_ozemail.com.au (Newcastle Permanent Building Society)
>Subject: Q: Comparing two tables in Oracle
>Date: 28 Apr 1995 01:11:00 GMT
>Summary: Comparing data in tables
>Keywords: table, oracle
 

>Currently our site is about to undertake a major migration to Oracle from
>a proprietary platform. To test whether the conversion has been
>successful we need to compare groups of tables in the same tablespace,
>different tablespaces, and different databases.
 

>e.g. Comparing the data in BORROWER table with data in
> OLD_BORROWER table
 

>We will be dealing with quite large tables and our current approach was
>that programs were written in PRO*COBOL to compare data on a field level
>and spitting out details when fields did not match. This was a very slow
>option and I was wondering if there was any other way to do it or if
>there was some third party software that existed to do this.

>Thanks in advance for any help or suggestion,
 

>PETER HAYES DBA, Analyst/Programmer, Chief cook and Bottlewasher

Export the two sets of tables in the same order and use an operating system comparison utility on the two DMP files if you just want to make sure they are identical. Will be fast but won't help find the differences.

Lawrence.... Received on Mon May 01 1995 - 00:00:00 CEST