Re: SECUREFILES disaster

From: Jonathan Lewis <>
Date: Fri, 27 Apr 2012 20:54:54 +0100
Message-ID: <>

"Noons" <> wrote in message news:jn65ch$3qa$
| I share this experience as well. A while ago I was
| involved in a db design that required updates to a LOB.
| We ended up simply inserting a new version and deleting the
| old one: it was much faster than waiting for Oracle's
| "efficient" handling of LOB updates...

That's odd, because if you haven't written code to do page-based updates to LOBs, Oracle deletes the old one and inserts a new one when you do an update.


Jonathan Lewis
Oracle Core (Apress 2011)
Received on Fri Apr 27 2012 - 14:54:54 CDT

Original text of this message