Re: ORA-01658. Puzzling =(

Mio Marquez wrote:
> 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.
>
> 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.

If you take the sum out of your query, you will see a list of all available extents in that tablespace. There must be a single extent big enough to hold the initial extent of your table. If there isn't, you will need to either add a datafile big enough to handle the extent, or decrease the size of your initial extent to the size of the biggest extent available.

Unless you have a good reason for creating tables in SYSTEM, I would suggest creating another tablespace and creating your tables there. Most standard Oracle installation have a 'USERS' tablespace you could probably use. Received on Tue Aug 11 1998 - 07:49:30 CDT