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: ideas to use ora hash

Re: ideas to use ora hash

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Wed, 22 Mar 2006 10:37:39 -0600
Message-ID: <de807caa0603220837x2811dbdbya8b6ef1fd4f0adcd@mail.gmail.com>


I have a task to compare two large tables on different databases. All columns need to be compared for changes. Would a hash value reduce the amount of data to compare?

Dennis Williams

On 3/21/06, Jared Still <jkstill_at_gmail.com> wrote:
>
> I use it to track changes to database objects,
> specifically, has an object changed since the
> last time I checked.
>
>
> On 3/21/06, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
>
> > Hi list
> > Does anyone has an interesting idea about how to use, specially for
> > tuning,
> > ora_hash or DBMS_UTILITY.GET_HASH_VALUE, to get hash values.
> >
> > One is to encrypt, but I was asking about the possibility to use to
> > reduce storage space or to tune, does anyone can share some idea
> > and/or experience.
> >
> > Thank you :)
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 22 2006 - 10:37:39 CST

Original text of this message

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