Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Quick and dirty way to compare table contents

Re: Quick and dirty way to compare table contents

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Wed, 22 Feb 2006 14:50:15 -0700
Message-ID: <057401c637f9$f77f3050$0400a8c0@porgand> 





> One easy way to prove that data is NOT identical would be fully analyzing 

> the tables with 254 bucket histograms on all columns and then comparing 

> the generated statistics.




This analyzing has to be done on the same version though and there might be 
other issues affecting outcoming statistics, so it's not 100% accurate..



Tanel.


--
http://www.freelists.org/webpage/oracle-l


Received on Wed Feb 22 2006 - 15:50:15 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US