Unable to Extend Table in Tablespace


SQLException ORA-01653 error message is logged.

Log message:

Error: SQLException: ORA-01653: unable to extend table ORACLE.RATECDR by 8192 in tablespace NEXOSS


The tablespace needs to be extended. You can create an additional datafile from the sqlplus command line, or by using the dbconsole.


SQL> alter tablespace nexoss
2 add datafile '/home/ossadmin/ORA/oracle/oradata/oss/nexoss02.dbf'
3 size 5g;
Tablespace altered.
SQL> quit