RE: Quick and dirty way to compare table contents

From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
To: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
Date: Wed, 22 Feb 2006 15:08:42 -0500

Sounds like you already know what you want.

 

________________________________

From: Ranko Mosic [mailto:ranko.mosic@xxxxxxxxx] 
Sent: Wednesday, February 22, 2006 3:07 PM
To: Mercadante, Thomas F (LABOR)
Cc: Guang Mei; _oracle_L_list
Subject: Re: Quick and dirty way to compare table contents

 

I think my boss wants programmatic solution here, something like
summarizing data in certain columns and comparing values. 

 

Regards, Ranko

 

On 2/22/06, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote: 

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 <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;

 

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 




-- 
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

RE: Quick and dirty way to compare table contents

Other related posts: