Tablespace fragmentation

From: <tec26t_at_hotmail.com>
Date: Thu, 27 Jan 2000 12:16:05 GMT
Message-ID: <86pcu3$3uo$1@nnrp1.deja.com>

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:16:05 CST