Re: SECUREFILES disaster

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 27 Apr 2012 20:54:54 +0100
Message-ID: <jJSdnUiDLvLIZAfSnZ2dnUVZ8gmdnZ2d_at_bt.com>

"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:jn65ch$3qa$1_at_dont-email.me...
|
| 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/9781430239543

Received on Fri Apr 27 2012 - 14:54:54 CDT

This message: [ Message body ]
Next message: Jonathan Lewis: "Re: SECUREFILES disaster"
Previous message: Jonathan Lewis: "Re: very impressed by 11g"
Maybe in reply to: Mladen Gogala: "SECUREFILES disaster"
Next in thread: Noons: "Re: SECUREFILES disaster"
Reply: Noons: "Re: SECUREFILES disaster"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message