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.


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

Follow-Ups:

Re: Quick and dirty way to compare table contents
From: Tanel Põder

Re: Quick and dirty way to compare table contents
From: Ranko Mosic

References:
- Re: Quick and dirty way to compare table contents
  - From: Ranko Mosic
- RE: Quick and dirty way to compare table contents
  - From: Vadim Bobrov
- Re: Quick and dirty way to compare table contents
  - From: Maxim
- Re: Quick and dirty way to compare table contents
  - From: bill thater

Re: Quick and dirty way to compare table contents

Other related posts: