Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Problem with SYSTEM table extents
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;
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 Mon May 11 1998 - 16:50:08 CDT
![]() |
![]() |