Re: Compare CLOBs over dblink
- From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx, japplewhite@xxxxxxxxxxxxx
- Date: Mon, 1 Nov 2010 08:40:28 -0700 (PDT)
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
>http://www.watermatters.org
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
