Quick and dirty way to compare table contents

  • From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
  • To: _oracle_L_list <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 22 Feb 2006 14:39:35 -0500

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

Other related posts: