RE: Quick and dirty way to compare table contents
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <ranko.mosic@xxxxxxxxx>, "Guang Mei" <GMei@xxxxxx>
- Date: Wed, 22 Feb 2006 15:02:05 -0500
Well can you:
Create table cpytable1 as select * from table1;
Export cpytable1;
Import cpytable1 into other database.
Then use minus to compare the two tables?
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ranko Mosic
Sent: Wednesday, February 22, 2006 2:54 PM
To: Guang Mei
Cc: _oracle_L_list
Subject: Re: Quick and dirty way to compare table contents
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/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
Other related posts:
