This content has been marked as final. Show 4 replies
When you created your application table "articles_rdf_data" did you set the tablespace?
SQL> create table xyz(i int) tablespace rdf_tblspace;
If you don't want to set it explicitly, you need to change the session user's default
tablespace. Assume your session user is scott
SQL> ALTER USER scott DEFAULT TABLESPACE rdf_tblspace;
sorry for the late reply. i didn't set the tablespace as rdf_tblspace explictly when i created the table articles_rdf_data. that's why the created table is using the default tablespace sysaux. now i need to change the default tablespace as rdf_tblspace. thanks for your help.
another issue: it is said in the developer's guide that 'Duplicate triples are not stored in the database.' however, when i inserted a duplicate triple in a table, it didn't stop it. so, how can i configure the database to prevent duplicate triples to be stored in the database. thanks in advance.
We take out duplicates when triples are stored in MDSYS schema (behind the scenes). That's why if you query MDSYS.RDFM_<model_name> view, you will not find any duplicates.
Duplicates will show up in your application table if you insert a triple multiple times into the same application
table. These duplicates will not affect the results of SPARQL queries.