RE: Quick and dirty way to compare table contents

From: Vadim Bobrov <vadimbobrov_at_gmail.com>
Date: Wed, 22 Feb 2006 15:54:16 -0500
Message-ID: <!&!AAAAAAAAAAAYAAAAAAAAALfInlLIKt5BvFMVgTrLO6iChwAAEAAAAChv+dr1VVhLtxsyu+7OVLEBAAAAAA==@gmail.com>

Export both tables to different files and then checksum the files. You might need to edit the files before checksumming though...

Vadim Bobrov
Oracle Database Tools
http://www.fourthelephant.com

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ranko Mosic
Sent: Wednesday, February 22, 2006 3:49 PM To: dofreeman_at_state.pa.us
Cc: _oracle_L_list
Subject: Re: Quick and dirty way to compare table contents

Yes, I am thinking about applying some function to all the data. Maybe summarize all numerical columns. I don't know what to do with character columns.

On 2/22/06, Freeman, Donald <dofreeman_at_state.pa.us> wrote:

Sounds like you need a way to hash the whole table and compare the hash results. I bet you could write a little procedure to do that.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ranko Mosic
Sent: Wednesday, February 22, 2006 2:40 PM To: _oracle_L_list
Subject: Quick and dirty way to compare table contents

Hi list,
I need to quckly compare tables in 2 schemas to verify contents are identical.
Counting blocks/rows, using tools to compare schemas is not possible. Something similar to checksum mechanism is requested. Any ideas ?

--

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/ContractSeniorOracleDBARankoMosicM ain.html
<http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosic Main.html>

--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 22 2006 - 14:54:16 CST