Re: Comparing Tables?

Check out the DBMS_RECTIFIER_DIFF package and DIFFERENCES, RECTIFY procedures. Must have advanced replication option installed.

syakobson_at_erols.com wrote:
>
> This will work only if both tables can not have duplicate rows. MINUS
> returns all distinct rows selected by the first query but not the second.
> Therefore if table 1 contains row A n times and table 2 contains it m
> times your solution will assume both tables are identical.
>
> Solomon Yakobson.
>
> In article <346af55d.12422225_at_69.0.9.9>,
> tim.hall_at_spam.begone wrote:
> >
> > On Thu, 13 Nov 1997 08:34:30 GMT, mhunter_at_iadfw.net (M. Hunter) wrote:
> >
> > > Is there an Oracle command or utility to compare the data in 2
> > >tables (same structure) and report any differences.
> > > Thanks in Advance
> >
> > Try
> >
> > SELECT * FROM table1
> > MINUS
> > SELECT * FROM table2;
> >
> > followed by
> >
> > SELECT * FROM table2
> > MINUS
> > SELECT * FROM table1;
> >
> > Of course, if the tables aren't exactly identical, with the columns
> > created in the same order, you will have to replace '*' with the
> > column list.
> > -----------------------------------------------------
> > Tim Hall, Indus International (was TSW International)
> >
> > http://www.tswi.com
> > http://www.indusgroup.com
> >
> > Replace domain name with the domain from the first URL before replying via email!
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
 

-- 
Gary Melhaff
Senior Database Analyst
Weyerhauser Corporation