Re: error

From: Brian Houghtby <b.houghtby_at_eaglecrusher.com>
Date: Mon, 13 Mar 2006 19:30:32 GMT
Message-ID: <sLjRf.12037$g91.2157@tornado.ohiordc.rr.com>

"Andrew Hardy" <junkmail@[127.0.0.1]> wrote in message news:dv4esd$eqn$1_at_sun-cc204.lut.ac.uk...
> Brian Houghtby wrote:
>> I am trying to run a procedure that was written for us by our MRP vendor
>> who is no longer in business. I am getting the following error. This is
>> an Oracle8i database running on Netware 5.1.
>>
>> begin
>> ops_archive_all;
>> end;
>>
>> ORA-01653: unable to extend table SYSADM.IC_TRANSACT_ARCHIVE by 177512 in
>> tablespace SYSTEM
>> ORA-27039: create file failed, file size limit reached
>> OSD-02067: illegal option specified
>> ORA-27039: create file failed, file size limit reached
>> OSD-02067: illegal option specified
>> ORA-06512: at "SYSADM.OPS_ARCH_AND_PURGE", line 29
>> ORA-06512: at "SYSADM.OPS_ARCHIVE_ALL", line 5
>> ORA-06512: at line 2
> You've run out of space for your table to expand into. It also looks like
> the tablespace is trying to autoexpand to fit the new requirements, but
> has hit a limit - either you set a maximum limit for the tablespace or
> there is no room on the device.
>
> Also... you really shouldn't have installed objects in the SYSTEM
> tablespace as there's always the danger that your application problems may
> one day cause the database to get very sick.
>
> --
> Andy

I am kind of a newbie at all this. Any recommendations on a fix? Received on Mon Mar 13 2006 - 13:30:32 CST