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:40:21 -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.

Tanel.

----- Original Message ----- From: "bill thater" <shrekdba@xxxxxxxxx>
To: <mdemenko@xxxxxxxxx>
Cc: <vadimbobrov@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, February 22, 2006 2:26 PM
Subject: Re: Quick and dirty way to compare table contents



On 2/22/06, Maxim <mdemenko@xxxxxxxxx> wrote:


Don't think it will work ( possible different nls settings, statistics come
in mind), but even simply exported the same schema twice ( into different
files) and got different checksums for both files.

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


Other related posts: