Re: How to Defrag a Tablespace?

From: LE GAL Thierry <Thierry.Le-gal_at_vz.cit.alcatel.fr>
Date: Fri, 29 May 1998 16:22:36 +0200
Message-ID: <356EC4AC.EC15CE2F@vz.cit.alcatel.fr>

hello,
You can check the view dba_free_space, dba_extents,dba_segments. You cat reduce the fragmentation by sizing correctly your objects and alter the nextextent size if they get to muuch extents.

T. Le Gal

Luca Minudel wrote:

> I've USER tablespace made of 1 datafile of 100 MByte, 25MByte are free (auto-extent is off).
> When I create a new table with an Initial Extent of 9MByte I get error ORA-1658: "Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created."
> How can I check tablespace fragmentation? How can I reduce tablespace fragmentation when it's fragmented?
>
> ___________________________________________________
> Luca Minudel software designer
> Italy Conegliano (TV)
> voice & fax +39 (0)438 412280
> e-mail luca.minudel_at_nline.it
> WWW (italian language used)
> http://www.geocities.com/SiliconValley/Vista/4041
Received on Fri May 29 1998 - 09:22:36 CDT