Re: Free space

From: Holger Spangardt <Holger.Spangardt_at_web.de>
Date: Wed, 05 Dec 2001 23:15:28 +0100
Message-ID: <3C0E9C80.5990597D@web.de>

Hi,

alter tablespace XXX coalesce;
startet as sys should defrag the extents in a tablespace. Oracle 8i is said to do this automatically (, but I don't really trust :-). Sometimes it is possible to resize the datafiles after. If free blocks aren't used in the tablespace this should help. If Oracle is still trying to extent the datafile the extentsize does not fit to the free extents. Usually Oracle tries to find free extents in the existing datafile.

Hope this helps,

Holger

BLANC Philippe schrieb:

> Hello,
> How can i move free contigus space in the end of a tablespace.
> Please help me, I haven't got any space in my disk and oracle don't use the
> free space in the begin of my tablespace.
Received on Wed Dec 05 2001 - 16:15:28 CST