Maybe something like this ( I think most people had already suggested this)? $ sqlplus / @t.sql > test $ cksum test 2704486432 489 test The t.sql would be just selecting all the data from each table..there're probaby fancier ways to do this.. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ranko Mosic Sent: Wednesday, February 22, 2006 12:49 PM To: dofreeman@xxxxxxxxxxx Cc: _oracle_L_list Subject: Re: Quick and dirty way to compare table contents Yes, I am thinking about applying some function to all the data. Maybe summarize all numerical columns. I don't know what to do with character columns. On 2/22/06, Freeman, Donald <dofreeman@xxxxxxxxxxx> wrote: 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxx http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMo sicMain.html -- 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/ContractSeniorOracleDBARankoMo sicMain.html