4 Replies Latest reply on May 20, 2010 2:49 PM by 715399

    *ORA-00972: identifier is too long* when drop app table index

    766393
      Hi,

      I have been having some difficulties with dropApplicationTableIndex. It raised an ORA-00972 exception :
      java.sql.SQLException: ORA-00972: identifier is too long

           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
           at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
           at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
           at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
           at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1657)
           at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1626)
           at oracle.spatial.rdf.client.jena.Oracle.executeUpdate(Oracle.java:769)
           at oracle.spatial.rdf.client.jena.GraphOracleSem.dropApplicationTableIndex(GraphOracleSem.java:3695)


      However, the longest name of my models is 23 characters, which makes the longest name of a table 27 characters (+ _TPL).
      Is there an even shorter limit for model name length ?

      Thanks

      Regards,
      Julien