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;"
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
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;"
Microsoft Windows 2003
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 )