Oracle table compare (data not file) functionality required ...

From: <ross_mcadam_at_my-dejanews.com>
Date: Wed, 25 Nov 1998 03:15:10 GMT
Message-ID: <73fsnj$q3g$1@nnrp1.dejanews.com>

I am looking for a utility which can identify the data differences between 2 identical tables. The differences would be identified based on the primary key of the table. Ideally the utility will output data to a transaction file, detailing the change - INSERT, DELETE or UPDATE. All data for non key columns must be included for the INSERT and UPDATE.

It would be really good if the utility went a further step and actually applied the changes to the destination table.

Note that the destination table is on a oil rig in the Timor Sea with a satellite link. Large data bases are involved so minimum data transfer is a must. Replication is not a solution as the source table is truncated on a daily basis.

Thanks in Advance. RM.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 24 1998 - 21:15:10 CST