1 Reply Latest reply: May 17, 2011 7:53 PM by alwu-Oracle RSS

    Bulk Loader error ORA-1408: ALTER TABLE EXCHANGE PARTITION

    Martin Jarvis
      Hi,

      I'm trying to load some existing tripples into my database (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 ) using the Java bulk loader. It seems to get so far (69 triples processed) then throws an error.

      [martin@victor-three rdf]$ sh load.sh
      Note: You can use JVM properties -Ddb.user=<user> -Ddb.password=<password> -Ddb.host=<host> -Ddb.sid=<sid> -Ddb.port=<port> to configure database connection.
      JVM property -Dappend=true can be used to specify APPEND mode. By default, this option is false.
      JVM property -Dexchange=true can be used to allow table partition exchange which is faster and less space consuming.
      This option is less robust though. By default, it is false

      Connecting to jdbc:oracle:thin:@localhost:1521:orcl as user ab
      Insert mode
      Load triples into one column and populate another ID column
      Batch loading started...
      Subject: <http://freakent.co.uk/addressbook/phone-numbers/447xxxxxxx0>
      Property: <http://freakent.co.uk/addressbook/phone-numbers/number>
      Object: "+447xxxxxxx0"

      Loading up to rows = 69
      java.sql.SQLException: ORA-55315: batch load attempt failed: SQLERRM=ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 5929
      ORA-06512: at "MDSYS.MD", line 1723
      ORA-06512: at "MDSYS.MDERR", line 17
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 5950
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 5960
      ORA-06512: at "MDSYS.RDF_APIS", line 1283
      ORA-06512: at line 1

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
      at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
      at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
      at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
      at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4693)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
      at oracle.spatial.rdf.client.NTripleConverter.loadNTriple(NTripleConverter.java:648)
      at oracle.spatial.rdf.client.BatchLoader.main(BatchLoader.java:302)
      [martin@victor-three rdf]$

      Is there some step I have missed when creating my semantic model and it's table?

      Many thanks,
      Martin