Re: Compare CLOBs over dblink
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: kjped1313@xxxxxxxxx
- Date: Mon, 1 Nov 2010 11:59:23 -0400
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@xxxxxxxxx>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@xxxxxxxxx>
> *To:* japplewhite@xxxxxxxxxxxxx
> *Cc:* Sherrie.Kubis@xxxxxxxxxxxxxxxxxx; "oracle-l@xxxxxxxxxxxxx" <
> oracle-l@xxxxxxxxxxxxx>; oracle-l-bounce@xxxxxxxxxxxxx
> *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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxx>
>> To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
>> Date: 11/01/2010 09:36 AM
>> Subject: Compare CLOBs over dblink
>> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
>> ------------------------------
>>
>>
>>
>> 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@xxxxxxxxxxxxxxxx* <Sherrie.Kubis@xxxxxxxxxxxxxxxx>
>> *
>> **http://www.watermatters.org* <http://www.watermatters.org/>
>>
>>
>>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
>
Other related posts:
