I am a newbie of oracle semantics technology. I got a question that I don't understand why the created table 'articles_rdf_data' is not under the created tablespace 'rdf_tblspace' but in the default tablespace 'SYSAUX'? I created a table space named articles_rdf_data and a semantic data network using this tablespace. after i created the table 'articles_rdf_data' and a semantic model 'articles' which uses the created tablespace, and then i logged into the OEM to check it, i found this table is using the default tablespace 'SYSAUX' rather than the created tablespace which i thought it should use. Thanks in advance.
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.