| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> How to Defrag a Tablespace?
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 Mon May 25 1998 - 16:26:22 CDT
![]() |
![]() |