Re: defragment LOB tablespace

From: damorgan <damorgan_at_exesolutions.com>
Date: Wed, 03 Apr 2002 17:06:45 GMT
Message-ID: <3CAB36AB.34F71751@exesolutions.com>

My recommendation would be to create a new locally managed tablespace with uniform extents. Export the data and then import it into the new tablespace.

Gets rid of the current fragmentation ... and it never comes back.

Daniel Morgan

Vadim Grepan wrote:

> Hello All!
>
> We need to reload some files into BLOB-tablespace. Unfortunatly
> it's impossible because tablespace hasn't one large flat free
> extent\segment but a lot of small ones scattered around all tablespace.
>
> Are there any way or tools to defragment *existing* BLOB-tablespace? We
> havn't enough disk space to create new BLOB-tablespace to load
> (or move by clause 'ALTER TABLE .. MOVE another_tspace') BLOB-data into
> it.
>
> Rgds, Vadim Grepan
> ------------------------
> Moscow, Russia
Received on Wed Apr 03 2002 - 11:06:45 CST