Hope that helps
Ranko Mosic wrote:
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 <mailto: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;
-----Original Message----- *From:* oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx> [mailto: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
I need to quckly compare tables in 2 schemas to verify
contents are identical.
Counting blocks/rows, using tools to compare schemas is not
Something similar to checksum mechanism is requested. Any ideas ?
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
email: mosicr@xxxxxxxxxx <mailto:mosicr@xxxxxxxxxx>