Re: unable to create initial extent

From: <ngroves_at_ndsuk.com>
Date: Wed, 16 Jun 1999 10:08:24 GMT
Message-ID: <7k7t2l$ghm$1@nnrp1.deja.com>

In article <7k7k09$e73$1_at_nnrp1.deja.com>, chitnis_at_pspl.co.in wrote:
> I created a new database instance (Oracle 7.3) on Solaris. Thereafter
I
> executed the catalog and catproc scripts.
>
> When I try to create a table in this instance, I get the following
> error message :
>
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> SYSTEM
>
> I tried to resize the database but i got the ora-406 error :
> COMPATIBLE parameter needs to be 7.2.0.0.0 or greater

>
> Any idea whats going wrong ?
>
> Thanks
> Chitnis
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Compatible is an init parameter - set it to 7.3.whatever_your_current_version_is, then bounce your database. You should then be able to resize .

The 1658 means you don't have enough contiguous space to create the table in the system tablespace. Are you sure you really want to use the system tablespace for tables?

regards
nigel groves

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 16 1999 - 05:08:24 CDT