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@xxxxxx> 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@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/ContractSeniorOracleDBARankoMosicMain.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/ContractSeniorOracleDBARankoMosicMain.html