Re: Compare CLOBs over dblink

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 1 Nov 2010 15:35:44 +0000
Message-ID: <AANLkTin9XR=ERHODbYgsgo6UnXo3=bYfXJHB8=vdA_zF_at_mail.gmail.com>

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:35:44 CDT