Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to Defrag a Tablespace?

How to Defrag a Tablespace?

From: Luca Minudel <luca.minudel_at_nline.it>
Date: 25 May 1998 21:26:22 GMT
Message-ID: <01bd8822$17944320$0100007f@w95luca>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US