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!

Error Batch Loading N-Triple Format Semantic Data Using the Java API

yenierDec 17 2016 — edited Dec 19 2016

Hi all:

I'm trying insert semantic data storage in N-Triple format (*.nt extension file), running the following command (Windows system) as is indicated in https://docs.oracle.com/database/121/RDFRM/GUID-1E972D71-0BBE-459E-8075-538ABE4F5911.htm#RDFRM598

java -Ddb.user=kegg -Ddb.password=kegg -Ddb.host=localhost -Ddb.port=1521 -Ddb.sid=orcl -Dappend=true -Dcharset="UTF-8" -classpath %ORACLE_HOME%\md\jlib\sdordf.jar;%ORACLE_HOME%\jdbc\lib\ojdbc6.jar oracle.spatial.rdf.client.BatchLoader C:\Users\Yenier\Desktop\dados\kegg-drug.nt rdf_data rdf_users kegg_mat

But it returns the following error:

Temporary table already exists!

java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

ORA-06512: em "MDSYS.SDO_RDF_INTERNAL", line 9731

ORA-06512: em "MDSYS.SDO_RDF_INTERNAL", line 9750

ORA-06512: em "MDSYS.RDF_APIS", line 1759

ORA-06512: em line 1

More details are showed in the next figure:

What can I do?

I guess to dropping this temporary table, the problem will be resolved, but I don't know what is the table name in MDSYS user.

Thanks,

Yenier

This post has been answered by alwu-Oracle on Dec 19 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 16 2017

Added on Dec 17 2016

#database-key-features, #rdf-graph-property-graph

2 comments

407 views