When using Emerald the message "[ORACLE][ODBC][ORA]ORA-01655: UNABLE TO EXTEND CLUSTER ... IN TABLESPACE ..." is displayed. What causes this and how can the problem be corrected?
Sep 14 2009
This is not an Emerald related issue. We strongly recommend consulting your Oracle DBA for resolution of this problem.
The following query can be used to display Oracle data files associated with table spaces used by Oracle:
SELECT file_name, bytes,MAXBYTES , status, autoextensible FROM dba_data_files
If usage of the tablespace associated with your database is too close to the maximum limit the following command can be used to enable unlimited growth of the data file.
ALTER DATABASE DATAFILE 'replace-with-full-path-name-to-my-data-file' AUTOEXTEND ON MAXSIZE UNLIMITED;
For example on an OracleXE system on the Linux platform extending the system tablespace:
ALTER DATABASE DATAFILE '/usr/lib/oracle/xe/oradata/XE/system.dbf' AUTOEXTEND ON MAXSIZE UNLIMITED;