Re: Compare CLOBs over dblink

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
>http://www.watermatters.org
>  


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info



      

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