Re: Problem with SYSTEM table extents

Sounds like you've used all your SYSTEM tablespace, or at least eliminated any freespace large enough to contain the initial extent which is required for your extension. I'm not sure if it's possible, but see if you can do an "alter tablespace system coalesce" (or something like that)(must be 7.3 or greater, I believe); this might bring together some free blocks to allow you room for the extent you need. If your SYSTEM tablespace is extremely fragmented make sure that only the user SYS has the SYSTEM tablespace as his/her default tablespace.\

As always speaking for myself,

cpw

In article <6j7rqh$m85$1_at_nnrp1.dejanews.com>, collins_at_myriadgate.net wrote:

> When I try to create a synonym as a user, I get the following
> message:
>
> 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!
>
> Any help would be appreciated!
>
> Thanks,
> j
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu May 14 1998 - 21:50:04 CDT