Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: defragment LOB tablespace

Re: defragment LOB tablespace

From: Vadim Grepan <kezal_at_mail.ru>
Date: Wed, 03 Apr 2002 10:54:43 +0400
Message-ID: <3CAAA733.5E2982B6@mail.ru>


add-on: Oracle 8.1.7.1 on Solaris 2.7

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 - 00:54:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US