| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: defragment LOB tablespace
Hello damorgan!
damorgan wrote:
> 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.
I've said we havn't enough disk space to create new tablespace or export all
data from existing one.
Uniform extents are not in effect
Rgds, Vadim Grepan
>
>
> 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 Thu Apr 04 2002 - 07:10:21 CST
 |
 |