Re: SECUREFILES disaster

From: Noons <>
Date: Tue, 24 Apr 2012 22:13:04 +1000
Message-ID: <jn65ch$3qa$>

Mark D Powell wrote,on my timestamp of 23/04/2012 11:33 PM:

> The LOB data type has never been known for its space efficiency.

Aye! Indeed!...

 > of separate LOB columns each holding a portion of the existing
> data that serves aspecific purpose or involve some form of
> versioning so that multiple rowsexist where new versions of
> the data result in new rows in the table.
> Potentially old versions or old enough versions could be purged
> freeingentire LOB's allowing better reuse of LOB space.

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... Received on Tue Apr 24 2012 - 07:13:04 CDT

Original text of this message