4 Replies Latest reply on Oct 13, 2016 12:31 PM by 3274437

    Drop and create rdf model

    3274437

      Dear all,

       

      I have a problem with drop/create a rdf model. If I try to drop a model named "test_mat" it says that it does not exist, and if a try to create a model with the same name it says that already exists.

       

      execute sem_apis.drop_rdfview_model(model_name => 'test_mat');
      
      Error: 
      ORA-55300: model TEST_MAT does not exist 
      ORA-06512: em "MDSYS.MD", line 1723
      ORA-06512: em "MDSYS.MDERR", line 17
      ORA-06512: em "MDSYS.SDO_RDF_INTERNAL", line 12205
      ORA-06512: em "MDSYS.SDO_RDF_INTERNAL", line 15434
      ORA-06512: em "MDSYS.SDO_RDF", line 3884
      ORA-06512: em "MDSYS.RDF_APIS", line 1287
      ORA-06512: em line 1
      
      execute sem_apis.create_sem_model('test_mat', 'RDF_DATA', 'triple');
      
      Error:
      ORA-13199:  Error in SDO_RDF.CREATE_RDF_MODEL: SQLERRM=ORA-55317: model "TEST_MAT" already exists dss=SELECT count("TRIPLE") FROM "RDF_DATA"
      ORA-06512: em "MDSYS.MD", line 1723
      ORA-06512: em "MDSYS.MDERR", line 17
      ORA-06512: em "MDSYS.SDO_RDF", line 1913
      ORA-06512: em "MDSYS.SDO_RDF", line 1953
      ORA-06512: em "MDSYS.RDF_APIS", line 1230
      ORA-06512: em line 1
      

       

      What is the best way to fix this?

       

      Thanks in advance,

      Elisa.