RE: Quick and dirty way to compare table contents

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Wed, 22 Feb 2006 15:02:05 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF680FEE@EXCNYSM0A1AJ.nysemail.nyenet>

Well can you:  

Create table cpytable1 as select * from table1;

Export cpytable1;

Import cpytable1 into other database.

Then use minus to compare the two tables?  

---

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:54 PM To: Guang Mei
Cc: _oracle_L_list
Subject: Re: Quick and dirty way to compare table contents  

Thanks Luis and Guang.

I personally like spool&diff option but my boss doesn't, so can't use that.

minus option is not an option because tables are in different databases, no link.    

On 2/22/06, Guang Mei <GMei_at_ph.com> wrote:

If you only need to compare the contents , you can use  

select * from table1 minus select * from table2;  

select * from table2 minus select * from table1;  

Guang

	-----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 - 14:02:05 CST