3 Replies Latest reply: Feb 27, 2014 2:18 PM by HansC RSS

    Create RDF table with datatype error on SDO_RDF_TRIPLE_S

    HansC

      Here is what I do,

       

      Oracle 12c Enterprice edition installed on Windows 7.

      sqlplus login sys as sysdba

      catsem.sql runs successfully.

      create tablespace rdf_tbl_space successfully

      exec sem_apis.create_sem_network('rdf_tbl_space') successfully

      alter session to container pdborcl succesfully

      create local user "test" successfully

      grant connect, resource, dba to test successfully

       

      login as user test

      create table test_rdf_data(id NUMBER, triple SDO_RDF_TRIPLE_S);

       

      It gives error: ORA-00902: invalid datatype which point to SDO_RDF_TRIPLE_S. I checked MDSYS schema and it has that type created already. Why it still gives error?

       

      Thanks for your help.