Re: table data diff
Date: Thu, 14 Feb 2002 21:59:13 +0100
Message-ID: <_FWa8.13221$B43.909593_at_news000.worldonline.dk>
In addition to Sybrand Bakker's reply, try asktom.oracle.com and click search/archive tab - as far as I can remember I believe I have seen a couple of scripts which dealt with the subject. Regards, Keld
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:a20d28ee.0202140240.3f2043c3_at_posting.google.com...
> "Sunil" <sunil_franklin_at_hotmail.com> wrote in message
news:<7VHa8.51$EC3.627_at_inet-nntp1.oracle.com>...
> > I am looking for a utility which can compare data differences between
two
> > tables ( having the same structure and pk ) in two different schemas.
Does
> > any one know of a utility that can do this or me.
> >
> >
> > Thanks in advance.
> > Sunil.
>
> the utility is called .................... SQL
>
> select *
> from tableA
> minus
> select *
> from tableB
>
> Please do not cross- or multipost.
>
> Hth
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Thu Feb 14 2002 - 21:59:13 CET