Re: Newbie: ORA-01653 and ORA-01119

In article <MPG.14e36348da7ccc259897fc_at_news.earthlink.net>,   Richard <huddler_at_earthlink.net> wrote:
> 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
>

Ignoring the fact you apparently have user objects in the system tablespace under the SYS id, since you have space on the disk, have you checked to see if you have filled the OS level file system? You did not specifiy how you are checking the space and maybe it is something simple. Have you checked the ulimit for the Oracle account? Was the database built on conventional files or were links to raw partitions used requiring you to first create another link and add it to the database?

Good luck.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com
http://www.deja.com/