Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: table data diff
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 - 14:59:13 CST