Re: Tablespace fragmentation

From: Cyril Zekser <cyril.zekser_at_cashware.fr>
Date: Thu, 27 Jan 2000 13:50:24 +0100
Message-ID: <38903F10.325CB35B@cashware.fr>

Simply create a Temporary tablespace, which will be mapped to all your volatile table... This will handle the fragmentation, and you'll have the "static" tablespace less fragmented.

HTH
Cyril

tec26t_at_hotmail.com a écrit :

> I'm looking for advice on tablespace fragmentation.
>
> A number of objects on a number of accounts write to the same
> tablespace. Some of these are volatile and this is causing alot of
> fragmentation.I end up having alot of free tablespace space but not
> contigious enough to create new objects or do reorganisations of
> existing objects.
>
> I was wondering if you could suggest options other than exporting
> everything, dropping the objects and starting as such from a clean
> slate. I just wonder if there are any interim steps that I could take to
> help things.
>
> We are on Oracle 7.3.4. Any help appreciated.
>
> Regards
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jan 27 2000 - 06:50:24 CST