Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!jfk3-feed1.news.algx.net!allegiance!news.maxwell.syr.edu!newsfeed.rt.ru!image.surnet.ru!surnet.ru!news1.relcom.ru!josh.sovintel.ru!not-for-mail
From: Vadim Grepan <kezal@mail.ru>
Newsgroups: comp.databases.oracle.server
Subject: Re: defragment LOB tablespace
Date: Thu, 04 Apr 2002 17:10:21 +0400
Organization: EDN Sovintel
Lines: 39
Message-ID: <3CAC50BD.184CD879@mail.ru>
References: <3CAA9FAC.6D6FF82@mail.ru> <3CAB36AB.34F71751@exesolutions.com>
NNTP-Posting-Host: 195.68.177.125
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: josh.sovintel.ru 1017925685 67137 195.68.177.125 (4 Apr 2002 13:08:05 GMT)
X-Complaints-To: usenet@news.sovintel.ru
NNTP-Posting-Date: 4 Apr 2002 13:08:05 GMT
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
Xref: easynews comp.databases.oracle.server:142017
X-Received-Date: Thu, 04 Apr 2002 06:07:59 MST (news.easynews.com)

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