Re: Quick and dirty way to compare table contents

Thanks to everybody guys, we can "close" this one. My boss settled for simple num_rows from dba_tables.

Appreciate your time & effort.
Ranko.

On 2/22/06, Tanel Põder <tanel.poder.003_at_mail.ee> wrote:
>
> 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_at_gmail.com>
> To: <mdemenko_at_gmail.com>
> Cc: <vadimbobrov_at_gmail.com>; <oracle-l_at_freelists.org>
> Sent: Wednesday, February 22, 2006 2:26 PM
> Subject: Re: Quick and dirty way to compare table contents
>
>
> > 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
>
>
>

--
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html

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