Error
in [Oracle]
|
Prev: 10.2 Upgrade Information Utility
Next: ORA-12842
From: Shredder on 19 Dec 2005 09:58 I am getting this error in our Oracle 8i database server running on Netware 5.1. It is generated from our MRP system that is the front end to the database. For a quick band-aid, can I archive some stuff and delete some records? ORA-01654: unable to extend index SYSADM.OPS_TRANS_IDX1 by 138254 in tablespace SYSTEM ORA-27039: create file failed, file size limit reached OSD-02067: illegal option specified ORA-27039: create file
From: Tom on 19 Dec 2005 10:06 > ORA-01654: unable to extend index SYSADM.OPS_TRANS_IDX1 by 138254 in > tablespace SYSTEM ORA-27039: create file failed, file size limit reached > OSD-02067: illegal option specified ORA-27039: create file your datafile(s) for that tablespace are at the limit of the OS i would imagine - add another datafile to the tablespace
From: hpuxrac on 19 Dec 2005 10:18 It is occuring for the SYSTEM tablespace. You probably need to either let the SYSTEM tablespace expand ( may not be possible if this is a RAW partition varies ) or add another datafile to the SYSTEM tablespace. It looks like the MRP package ( or one of your DBA's ? ) has a schema SYSADM that is allocating space from the SYSTEM tablespace. Do you need this schema? Is it a part of your MRP system or not? If you don't need it or can move it to another tablespace those are probably better alternatives.
From: Jimbo1 on 19 Dec 2005 10:19 Tom's solution would be the safest way. You could archive records from the tables concerned, BUT ONLY if you're certain they're not going to be needed immediately by the users of your system.
From: Shredder on 19 Dec 2005 10:27
"hpuxrac" <johnbhurley(a)sbcglobal.net> wrote in message news:1135005480.357743.254630(a)o13g2000cwo.googlegroups.com... > It is occuring for the SYSTEM tablespace. > > You probably need to either let the SYSTEM tablespace expand ( may not > be possible if this is a RAW partition varies ) or add another datafile > to the SYSTEM tablespace. > > It looks like the MRP package ( or one of your DBA's ? ) has a schema > SYSADM that is allocating space from the SYSTEM tablespace. > > Do you need this schema? Is it a part of your MRP system or not? > > If you don't need it or can move it to another tablespace those are > probably better alternatives. > Yes, that schema is needed. |