error occurred at recursive SQL level 1 ORA-01654: unable to extend (Legacy KB ID CNC TS30085 )

Document ID : KB000052007
Last Modified Date : 14/02/2018
Show Technical Document Details
It is possible to set autoextend to on by using the following command: "ALTER DATABASE DATAFILE '<PATH>/<DATA_FILE.DBF>' AUTOEXTEND ON;". An example of the complete command is : "ALTER DATABASE DATAFILE '/mnt/volume24/data/oradata/EHEALTH/SYSTEM01.dbf' AUTOEXTEND ON;"

Related Issues/Questions:
Upgrade from 5.7 to 6.1 fails with database error: -604 ORA-00604: error occurred at recursive SQL level 1 ORA-01654: unable to extend index SYS.I_COL3 by 128 in tablespace SYSTEM

Problem Environment:
alert_EHEALTH.log shows ORA-1654: unable to extend index SYS.I_COL3 by 128 in tablespace SYSTEM
Check whether AutoExensible is enabled with following query in sqlplus "select tablespace_name, autoextensible from dba_data_files;"
eHealth 6.1
Solaris 2.10
Solaris 2.9
Microsoft Windows 2003

Additional Information:
Use nhDbStatus to check available space in problem tablespace e.g. SYSTEM.
In Oracle 10g, if you see error: "ORA-32773: operation not supported for smallfile tablespace SYSTEM" it is likely that the command "ALTER TABLESPACE system AUTOEXTEND ON;" was used when setting AutoExtend. This error can be avoided by specifying the full path to the file.


(Legacy KB ID CNC TS30085 )