"ORA-01654: unable to extend index" While Running the Reconciliation in OIM

(Doc ID 880076.1)

Last updated on MARCH 27, 2018

Applies to:

Identity Manager - Version 9.1.0.2 to 9.1.0.2
Information in this document applies to any platform.

Symptoms

While running the reconciliation seeing following exception in server log.

009-08-20 23:24:25,237 ERROR [XELLERATE.DATABASE] Class/Method: tcDataBase/writeStatement encounter some problems: ORA-01654: unable to extend index OIM_USER.PK_RCD by 128 in tablespace OIM_DATA
java.sql.SQLException: ORA-01654: unable to extend index OIM_USER.PK_RCD by 128 in tablespace OIM_DATA
    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349)
    at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
    at com.thortech.xl.dataaccess.tcDataBase.writePreparedStatement(Unknown Source)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms