Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: defragment LOB tablespace
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
![]() |
![]() |