Re: Compare CLOBs over dblink
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Mon, 1 Nov 2010 11:19:55 -0500 (CDT)
Message-ID: <b731dbadeb433034aa954584d6350347.squirrel_at_society.servebeer.com>
> 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.
Date: Mon, 1 Nov 2010 11:19:55 -0500 (CDT)
Message-ID: <b731dbadeb433034aa954584d6350347.squirrel_at_society.servebeer.com>
> 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.
It should be noted that SHA1 hashes are not guaranteed to be 100% unique, but that they are *extremely* unlikely to collide. A quick Google shows the odds at 1 in 2^80.
Thought that disclaimer should be put in there, just in case... :)
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 01 2010 - 11:19:55 CDT