Re: Compare CLOBs over dblink
From: Kellyn Pedersen <kjped1313_at_yahoo.com>
Date: Mon, 1 Nov 2010 08:40:28 -0700 (PDT)
Message-ID: <601267.71989.qm_at_web120213.mail.ne1.yahoo.com>
Date: Mon, 1 Nov 2010 08:40:28 -0700 (PDT)
Message-ID: <601267.71989.qm_at_web120213.mail.ne1.yahoo.com>
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-lReceived on Mon Nov 01 2010 - 10:40:28 CDT