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

Home -> Community -> Usenet -> c.d.o.server -> ORA-01658. Puzzling =(

ORA-01658. Puzzling =(

From: Mio Marquez <mio.marquez_at_mailcity.com.nospam.please>
Date: Tue, 11 Aug 1998 20:46:38 +0800
Message-ID: <35D03D2D.1EA67A95@mailcity.com.nospam.please>


Hi.
When we try to create a new table, we get an "ORA-01658: Unable to create INITIAL extent for segment in tablespace SYSTEM" error. The doc says: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.

As the recommended action says, we've tried adding a new datafile into the SYSTEM tablespace and when we try to create the table again, it still produces the same error. Curiously, does the word "CONTIGUOUS" play a very important role here?

A SELECT sum(bytes) FROM dba_free_space WHERE tablespace_name = 'SYSTEM'; returns 110,536,704.
Out of desperation, we've also tried changing the values of INITIAL (original value is 102,400K) and NEXT (original value is 102,400K) extents but still the same.
None of us are very well versed on internal workings of Oracle =(. We're using Oracle Workgroup Server 7.3.2.3.1 for Windows NT...

Is there anything that we might be missing here? Could somebody please help us by providing some detailed steps on how to deal with this problem....
Any help given is sincerely appreciated.

Thank you and God Bless.

Mio-Nino P. Marquez
Delphi Developer Received on Tue Aug 11 1998 - 07:46:38 CDT

Original text of this message

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