Re: compare records between 2 tables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 04 Dec 2001 19:51:38 +0100
Message-ID: <ro6q0u0f99d8782jfkgiu46qd8mppft67f@4ax.com>

On Tue, 4 Dec 2001 15:21:40 +0100, "Olivier VEIT" <oveit_at_infeurope.lu> wrote:

>Hello,
>I've written a 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 foo_at_remote
minus
select * from foo
/

Easy

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Dec 04 2001 - 12:51:38 CST