Re: ideas to use ora hash

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