Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem with SYSTEM table extents

Problem with SYSTEM table extents

From: <collins_at_myriadgate.net>
Date: Mon, 11 May 1998 21:50:08 GMT
Message-ID: <6j7rqh$m85$1@nnrp1.dejanews.com>


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 Mon May 11 1998 - 16:50:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US