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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 22 2006 - 14:33:13 CST
