RE: Quick and dirty way to compare table contents

  • From: "Khemmanivanh, Somckit" <somckit.khemmanivanh@xxxxxxxxxxxxxxxx>
  • To: <ranko.mosic@xxxxxxxxx>, <dofreeman@xxxxxxxxxxx>
  • Date: Wed, 22 Feb 2006 13:14:03 -0800

 
Maybe something like this ( I think most people had already suggested
this)?
 
$ sqlplus / @t.sql > test

$ cksum test
2704486432 489 test

The t.sql would be just selecting all the data from each table..there're
probaby fancier ways to do this..

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ranko Mosic
Sent: Wednesday, February 22, 2006 12:49 PM
To: dofreeman@xxxxxxxxxxx
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@xxxxxxxxxxx> 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxx
        
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMo
sicMain.html 
                 




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

Other related posts: