Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Temporary table already exists!

669888Nov 11 2008 — edited Nov 12 2008
Hi I am trying to use the oracle.spatial.rdf.client.BatchLoader to load triples into a semantic model. I get the following stack trace:

Temporary table already exists!
java.sql.SQLException: ORA-00955: name is already used by an existing object
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 3326
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 3362
ORA-06512: at "MDSYS.RDF_APIS", line 786
ORA-06512: at line 1

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
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.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:944)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3482)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3839)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1085)
at oracle.spatial.rdf.client.NTripleConverter.loadNTriple(NTripleConverter.java:391)
at oracle.spatial.rdf.client.BatchLoader.main(BatchLoader.java:302)


Unfortunately it doesn;t give me the name of the offending table so I can drop it. I was able to load triples in this manner until I had to interrupt a load partway through. If I try to run sem_apis.cleanup_batch_load as user MDSYS, however, I receive the following:

ORA-13199: Batch load cleanup failed. ORA-00942: table or view does not exist
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_RDF", line 891
ORA-06512: at "MDSYS.SDO_RDF", line 897
ORA-06512: at line 1

Again, I am not provided with the name of the offending table. Can someone please provide some insight as to how I can resolve this?

PS: It would be helpful if at least the code weren't obfuscated so one could follow these traces, esp. given the lack of documentation and bugginess
This post has been answered by alwu-Oracle on Nov 12 2008
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 10 2008
Added on Nov 11 2008
2 comments
3,690 views