3 Replies Latest reply: Feb 27, 2014 2:24 PM by Matperry-Oracle RSS

    Create RDF table with datatype error on SDO_RDF_TRIPLE_S


      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.