Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with SYSTEM table extents
Oracle creates a new system table filext$ to hols information about autoextend(s) the
first time you issue a statement with AUTOEXTEND option. Looks like your SYSTEM
tablespace is absolutely out of space (not even 10K free space to create the INITIAL
extent for filext$) and that is why your ADD DATAFILE statement is failing. You might try
ALTER DATABASE to resize your original datafile. Look at the online help for syntax.
This feature is available only from 7.3 (I think).
HTH
Venkat
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01654: unable to extend index SYS.I_SYN1 by 5 in tablespace SYSTEM
>
>That message (1654) says to add a datafile, so I try that:
>
> SVRMGR> alter tablespace SYSTEM
> add datafile '/opt/oracle7/dbs/sys2TEST.dbf'
> 2> autoextend on
> 3> next 10K
> 4> maxsize unlimited;
> alter tablespace SYSTEM add datafile '/opt/oracle7/dbs/sys2TEST.dbf'
> *
> ORA-03299: cannot create dictionary table filext$
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM
>
>Anyone have any idea why I can't create an INITIAL extent for the
>SYSTEM tablespace? What should I change? This is essentially the
>default installation "out of the box," and VERY little has been added
>to the tables, so I absolutely cannot be out of space!
Received on Mon May 11 1998 - 20:51:00 CDT