Re: Quick and dirty way to compare table contents

  • From: Tanel Põder <tanel.poder.003@xxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 22 Feb 2006 14:50:15 -0700

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.

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


Other related posts: