Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!feeder.qis.net!sn-xit-02!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.misc Subject: Re: record comparison between to tables Date: Wed, 12 Dec 2001 23:08:28 +0100 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <0alf1ugno8gnjln05vfcnjlv5e7eateu9o@4ax.com> Reply-To: postbus@sybrandb.demon-verwijderdit.nl References: <9v7v6q$3sv$1@wanadoo.fr> X-Newsreader: Forte Agent 1.8/32.548 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: newsabuse@supernews.com Lines: 24 Xref: easynews comp.databases.oracle.misc:73693 X-Received-Date: Wed, 12 Dec 2001 15:05:07 MST (news.easynews.com) On Wed, 12 Dec 2001 17:05:05 +0100, "Olivier VEIT" 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 @remotedb minus select * from
Hth Sybrand Bakker, Senior Oracle DBA To reply remove -verwijderdit from my e-mail address