Re: SECUREFILES disaster
Date: Fri, 27 Apr 2012 20:54:54 +0100
"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message
| 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.
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Oracle Core (Apress 2011) http://www.apress.com/9781430239543Received on Fri Apr 27 2012 - 14:54:54 CDT