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?

Brian wrote:
tablespace is on autoextend, but the file is on a RAW volume that does
not allow for the tablespace to automatically extend