Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01658. Puzzling =(
adjust the query:
Select max(bytes) from .......
The value returned is the max you can use for you intial extent.
Regards,
Alfons RIesebeek
Mio Marquez <mio.marquez_at_mailcity.com.nospam.please> schreef in artikel
<35D03D2D.1EA67A95_at_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 - 08:18:38 CDT
![]() |
![]() |