Re: tool to compare the content of two tables with same structure
From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Thu, 23 Sep 1999 10:16:11 +0100
Message-ID: <7scr52$n5g$1_at_taliesin.netcom.net.uk>
Date: Thu, 23 Sep 1999 10:16:11 +0100
Message-ID: <7scr52$n5g$1_at_taliesin.netcom.net.uk>
Pierre-Yves Kerbiquet <pkerbiqu_at_capgemini.fr> wrote in message
news:7scqmi$5kf$1_at_minus.oleane.net...
> Do you know any tool that quickly compare the content of two Oracle tables
> (that can be very big) with the same structure and reports if content is
the
> same or not.
As previously said in this ng sqlplus can do it
IIRC
select * from a
minus
select * from b
select * from b
minus
select * from a
if you get 'no rows' to both then the tables are identical
Alex Received on Thu Sep 23 1999 - 11:16:11 CEST