SUSPECT: RE: Quick and dirty way to compare table contents

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Wed, 22 Feb 2006 16:04:54 -0500
Message-ID: <51327ABA927BEF4B96590554CEA7832C290738@enhbgpri05.backup>

I'm guessing you wouldn't have check everything. You should be able to check 10-15% of the data to make a valid statistical conclusion that the tables are the same or not the same. As far as the character data you could probably transform it to numerical data and then summarize it. Or, like some others said, export the data and do file comparison on the export files.

	-----Original Message-----
	From: Ranko Mosic [mailto:ranko.mosic_at_gmail.com] 
	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/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:04:54 CST