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

True...if you add a datafile the datafile you added should be larger than the initial extents required to create all tables

Sybrand Bakker wrote:

> 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 Tue Jan 04 2000 - 02:00:46 CST