Re: Comparing data between 2 tables...

Thanks John,

I will look into that. That is exactly what I am looking for.

Joe

"John" <john_at_1startdepot.com> wrote in message news:<sVlk4Yd4CHA.341_at_newsgroup.korea.com>...
> Joe,
>
> You can do this compare with a tool called DBDiff for Oracle (see
> www.dkgas.com), it can compare not only your data, but also other objects if
> you need it too. It also comes on an ODBC version if you need to compare
> other databases.
>
> John
>
> "Joe" <RappaJ_at_nycha.nyc.gov> wrote in message
> news:ab8e8633.0303031339.58a3e6b0_at_posting.google.com...
> > Hello,
> >
> > Can someone please give me some tips on a simple way to compare all
> > columns and data on 2 tables in separate schemas in the same instance?
> >
> > I want to create a comparison report of, for example, MY.TABLE_SAL
> > -vs- THEIR.TABLE_SAL. I want to make sure that when I load Joe
> > Millionaires annual salary of $19,000 in MY.TABLE_SAL via sqlldr, they
> > also take the full $19000 and not just $1900 when they extracted the
> > data to be loaded into production.
> >
> > P.S. I'm not a DBA, so if some kind of DBA privies are needed for some
> > kind of tool or Data Dictionary table, please let me know.
> >
> > Any tips provided is appreciated.
> >
> > Thanks,
> > Joe
Received on Tue Mar 04 2003 - 07:45:24 CST