Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Quick and dirty way to compare table contents

Re: Quick and dirty way to compare table contents

From: Maxim <mdemenko_at_gmail.com>
Date: Wed, 22 Feb 2006 22:19:55 +0100
Message-ID: <8dde6bbd0602221319u2e512f5fs1d621fd7202a648b@mail.gmail.com>


Don't think it will work ( possible different nls settings, statistics come in mind), but even simply exported the same schema twice ( into different files) and got different checksums for both files.

Regards

Maxim

On 2/22/06, Vadim Bobrov <vadimbobrov_at_gmail.com> wrote:
>
> Export both tables to different files and then checksum the files. You
> might need to edit the files before checksumming though...
>
> Vadim Bobrov
> Oracle Database Tools
> http://www.fourthelephant.com
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Ranko Mosic
> *Sent:* Wednesday, February 22, 2006 3:49 PM
> *To:* dofreeman_at_state.pa.us
> *Cc:* _oracle_L_list
> *Subject:* Re: Quick and dirty way to compare table contents
>
> Yes, I am thinking about applying some function to all the data.
> Maybe summarize all numerical columns. I don't know what to do with
> character columns.
>
>
>
> On 2/22/06, Freeman, Donald <dofreeman_at_state.pa.us> wrote:
> >
> > Sounds like you need a way to hash the whole table and compare the hash
> > results. I bet you could write a little procedure to do that.
> >
> > -----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
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 22 2006 - 15:19:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US