IEA Software, Inc.

IEA Software Knowledge Base - ID:58388

IEA Knowledge base

Emerald (KB ID: 58388)

Sep 14 2009

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;