Issue:
SQLException ORA-01653 error message is logged.
Log message:
Error: SQLException: ORA-01653: unable to extend table ORACLE.RATECDR by 8192 in tablespace NEXOSS
Solution:
The tablespace needs to be extended. You can create an additional datafile from the sqlplus command line, or by using the dbconsole.
Example:
SQL> alter tablespace nexoss
2 add datafile '/home/ossadmin/ORA/oracle/oradata/oss/nexoss02.dbf'
3 size 5g;
Tablespace altered.
SQL> quit