Oracle Error -
09-06-2007
, 07:26 AM
I am getting the following error message on my oracle database. This is a
database that was created in 1999 and houses our MRP system for my work. I
get this error when trying to mass update one field in a table.
Error: ORA-01653: unable to extend table SYSADM.IC_STOCK_AUDIT by 27309 in
tablespace SYSTEM
ORA-27039: create file failed, file size limit reached
OSD-02067: illegal option specified
ORA-27039: create file
I assume there is a limit set on creation of this database. Is this a limit
per table (as in the IC_STOCK_AUDIT table) or is it a general limit for the
whole database. I guess what I need to know is, if I delete several
temporary tables created over the years, will it Band-Aid this for the time
being? Or would I need to delete records from the IC_STOCK_AUDIT TABLE? |