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:40:21 -0700
Message-ID: <054701c637f8$9611bdc0$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.

Tanel.

> On 2/22/06, Maxim <mdemenko_at_gmail.com> 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
Received on Wed Feb 22 2006 - 15:40:21 CST

Original text of this message

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