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_at_labor.state.ny.us> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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_at_ph.com> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org]*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_at_rogers.com
> http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
>
>
>
>
>
>
> --
> Regards,
> Ranko Mosic
> Contract Senior Oracle DBA
> B. Eng, Oracle 10g, 9i Certified Database Professional
> Phone: 416-450-2785
> email: mosicr_at_rogers.com
>
> http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
>

--
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html

--
http://www.freelists.org/webpage/oracle-l