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!

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:

Captura.JPG

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2017
Added on Dec 17 2016
2 comments
406 views