| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01658. Puzzling =(
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
![]() |
![]() |