Newbie: ORA-01653 and ORA-01119

Oracle Enterprise 8.1.5
SPARC 2.7 64 bit

Getting the error message

> ORA-01653: unable to extend table SYS.TCAS_TCPPKTDATA
> by 12137 in tablespace SYSTEM

when attempting to insert records into a database. Inserts are done via ODBC and JDBC, and were working with no problems until we hit some wall and started getting ORA-01653 two days ago.

The datafile storage is on path /data/oracledb/oradata/TCAS. /data is the sole partition on a very large disk. 16 GB of that space is currently AVAILABLE.

When I attempt to use the SQLPLUS interfact the ALTER TABLESPACE ADD DATAFILE, I get ORA-01119 (no space on device). I directly specify the '/data/oracledb/oradata/TCAS/<datafile>.dbf' -- but I still get an ORA- 01119. (There's 16 GB free on that device. I don't get it.)

When I attempt to simply resize the datafile '/data/oracledb/oradata/TCAS/system01.dbf' I get a file not found error.

I can list that file, currently sized at 183+ MB. I'm very sure I'm typing correctly.

I am going quite nuts over this. Any help greatly appreciated.

-- 
No one dies wishing they'd spent more time at the office.

This post simply contains some of my personal opinions.
ObURL:  http://home.earthlink.net/~huddler