Re: record comparison between to tables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 12 Dec 2001 23:08:28 +0100
Message-ID: <0alf1ugno8gnjln05vfcnjlv5e7eateu9o@4ax.com>

On Wed, 12 Dec 2001 17:05:05 +0100, "Olivier VEIT" <oveit_at_infeurope.lu> wrote:

>Hello,
>I use a self-developped replication script between an Intranet DB and
>Internet DB.
>Now, to test the replication, i would like to check the records between my
>two DB for the replicated tables to verify that everithing is well updated.
>I would like to check if, for the same primary key, the stored information
>is the same on the 2 DB.
>If you have suggestions, they are wellcome ;-)
>
>Thank you for your help
>

select * from <table>@remotedb
minus
select * from <table>

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Dec 12 2001 - 16:08:28 CST