RE: Quick and dirty way to compare table contents

From: Khemmanivanh, Somckit <somckit.khemmanivanh_at_weyerhaeuser.com>
Date: Wed, 22 Feb 2006 13:14:03 -0800
Message-ID: <65C0D8935651CB4D96E97CEFAC5A12B9010EB911@wafedixm10.corp.weyer.pri>

 

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ranko Mosic
Sent: Wednesday, February 22, 2006 12: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/ContractSeniorOracleDBARankoMo sicMain.html                  

-- 
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/ContractSeniorOracleDBARankoMo
sicMain.html 



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

Received on Wed Feb 22 2006 - 15:14:03 CST