Re: ideas to use ora hash
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: jkstill@xxxxxxxxx
- Date: Wed, 22 Mar 2006 10:37:39 -0600
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@xxxxxxxxx> 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@xxxxxxxxx> 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 :)
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
Other related posts:
