Re: Compare CLOBs over dblink

From: Andy Klock <andy_at_oracledepot.com>
Date: Mon, 1 Nov 2010 11:59:23 -0400
Message-ID: <AANLkTi=i_BKQTC6iexg4iuDZ27J9NzR5A-K_M8ru2ZCW_at_mail.gmail.com>

I don't have experience comparing "large" lobs over a db link, but I'd be inclined to use your dbms_crypto.hash method. Create a new function that just calls dbms_crypto.hash and grant execute on that to your developer.

On Mon, Nov 1, 2010 at 11:40 AM, Kellyn Pedersen <kjped1313_at_yahoo.com>wrote:

> I only had time to read the subject line and upon reading Niall's comment,
> this was my first thought- look at the sizes first before performing the
> compare. This could be painful....
>
>
> Kellyn Pedersen
>
> Sr. Database Administrator
>
> http://www.linkedin.com/in/kellynpedersen
>
> www.dbakevlar.blogspot.com
>
>
>
>
> ------------------------------
> *From:* Niall Litchfield <niall.litchfield_at_gmail.com>
> *To:* japplewhite_at_austinisd.org
> *Cc:* Sherrie.Kubis_at_swfwmd.state.fl.us; "oracle-l_at_freelists.org" <
> oracle-l_at_freelists.org>; oracle-l-bounce_at_freelists.org
> *Sent:* Mon, November 1, 2010 9:35:44 AM
> *Subject:* Re: Compare CLOBs over dblink
>
> How big do the LOBS get? I wouldn't want to compare multi mb files over a
> link....
>
> On Mon, Nov 1, 2010 at 3:28 PM, <japplewhite_at_austinisd.org> wrote:
>
>> How about the DBMS_LOB.Compare function?
>>
>> Jack C. Applewhite - Database Administrator
>> Austin I.S.D. - MIS Department
>> 512.414.9250 (wk) / 512.935.5929 (pager)
>>
>>
>>
>>
>> From: Sherrie Kubis <Sherrie.Kubis_at_swfwmd.state.fl.us>
>> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
>> Date: 11/01/2010 09:36 AM
>> Subject: Compare CLOBs over dblink
>> Sent by: oracle-l-bounce_at_freelists.org
>> ------------------------------
>>
>>
>>
>> I have a developer request to compare CLOB fields over a dblink. We
>> looked at dbms_utility.get_hash_value but that only works for varchar data
>> types. We then looked at dbms_crypto.hash, which has potential. My concern
>> with this is granting dbms_crypto to a developer as a security issue.
>>
>> Anyone have an experience or advice on comparing clobs over a dblink or
>> the dbms_crypto package?
>>
>>
>> *
>> Sherrie Kubis
>> Oracle DBA Supervisor*
>> Southwest Florida Water Management District
>> 352-796-7211 x4033*
>> **mailto:Sherrie.Kubis_at_watermatters.org* <Sherrie.Kubis_at_watermatters.org>
>> *
>> **http://www.watermatters.org* <http://www.watermatters.org/>
>>
>>
>>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
>

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

Received on Mon Nov 01 2010 - 10:59:23 CDT