Re: Defrag Tablespaces ? How ?

From: Ton Raaijmakers <torgan_at_worldonline.nl>
Date: Wed, 14 Oct 1998 13:33:47 +0200
Message-ID: <36248C1A.7E5E3802@worldonline.nl>

You can reorg a tablespace but you have to buy a utility. Tsreorg from Platinum can do this.

Ton Raaijmakers

Asko Tiidumaa wrote:

> > you can't export a tablespace, you can only export all tables in a
> > tablespace, indexes you must drop and recreate them (Release < 7.3) ...
> > Then you must drop the tablespace and recreate it or
> > set default storage (pctincrease 1) for it ( not 0) so that SMON
> > coalesces all free extents or
> > in Oracle release greater 7.3 "alter tablespace USERS coalesce;"
>
> but 24*7 availability?
>
> Asko Tiidumaa
Received on Wed Oct 14 1998 - 06:33:47 CDT