RE: Quick and dirty way to compare table contents

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/ContractSeniorOracleDBARankoMosicMain.html <http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html>  

--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 22 2006 - 13:45:06 CST