Re: ora-01658,unable to create initial extent for segment in table space system

Hi Anurag,

This means there is no free extent in the tablespace system greater than or equal to the extent size you are asking from it. You could verify this by running

select * from dba_free_space where tablespace_name = 'SYSTEM' and bytes >= <your extent>
/

This should return no rows.

As this is the system tablespace and reorganizing the system tablespace usually means recreating the database you need to enlarge the system tablespace.
I would simply resize the datafile if there is still space on the disk (alter database datafile '<filename>' resize <new_size> M) I would not add a datafile.

Hth,

--
Sybrand Bakker, Oracle DBA
Anurag <anurag_at_synergy-infotech.com> wrote in message news:210046ed.271c92b2_at_usw-ex0102-011.remarq.com...
> Hi,
> I was trying to intall jServer in Oracle 8i using the script
> initjvm.sql, and I got thew follow. error
> ora-01658,unable to create initial extent for segment in table space
> system
> Can somebody please tell me what does it mean.I referred the
> documentation, it says alter the tablespace and add a data file with
> smaller initial extent.I tried this also but it does not work.
> help will be appreciated,
> regards,
> Anurag
>
> PS. also reply at anurag_at_synergy-infotech.com
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Mon Jan 03 2000 - 10:37:07 CST