error occurred at recursive SQL level 1 ORA-01654: unable to extend (Legacy KB ID CNC TS30085 )
Article ID: 52007
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.