Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: defragment LOB tablespace
If you don't have enough space to export data to then you have no way to do
this. On the other hand as exp runs across a network quite happily this
would mean that you do not have enough disk space *anywhere* in your
organisation to export your data to. If this is really the case buy a new
drive or three quick.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Vadim Grepan" <kezal_at_mail.ru> wrote in message news:3CAC50BD.184CD879_at_mail.ru...Received on Thu Apr 04 2002 - 07:42:18 CST
> 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
> ------------------------
> Moscow, Russia
>
> >
> >
> > 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
>