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

Can you explain please. I don't understand why we shoud not add a datafile ?

Thanks

In article <3871A8AD.AF4CBBFF_at_cis.com.ph>,   Michael Puente <mcpuente_at_cis.com.ph> wrote:
> 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!
> > >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 04 2000 - 06:27:14 CST