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:08:42 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF680FEF@EXCNYSM0A1AJ.nysemail.nyenet>

Sounds like you already know what you want.

From: Ranko Mosic [mailto:ranko.mosic_at_gmail.com] Sent: Wednesday, February 22, 2006 3:07 PM To: Mercadante, Thomas F (LABOR)
Cc: Guang Mei; _oracle_L_list
Subject: Re: Quick and dirty way to compare table contents

I think my boss wants programmatic solution here, something like summarizing data in certain columns and comparing values.

Regards, Ranko

On 2/22/06, Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us> wrote:

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 <mailto: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:08:42 CST