Re: SECUREFILES disaster
Date: Tue, 24 Apr 2012 22:13:04 +1000
Message-ID: <jn65ch$3qa$1_at_dont-email.me>
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