1 Ответить Последний ответ: 02.10.2009 22:10, автор: alwu-Oracle

    Impossible to create a Semantic network

    725609
      Hi,
      i have pbm to create my semantic network. Below this is my pbm :

      Configuration : Oracle 11gR1 (11.1.0.7.0)

      Configuration MDSYS :

      OBJECT_NAME STATUS
      -------------------------------------------------------------------------------------------------------------------------------- -------
      RDF_MATCH VALID
      /c72364cb_RDFConstants VALID
      /c1b762e5_RDFException VALID
      RDF_APIS VALID
      SDO_RDF_MIG VALID
      RDF_APIS_OPER_INTERNAL VALID
      RDF_APIS_INTERNAL VALID
      SDO_RDF VALID
      RDF_APIS_USER VALID
      SDO_RDF_INTERNAL VALID
      RDF_APIS_OPER_INTERNAL VALID
      SDO_RDF VALID
      SDO_RDF_INTERNAL VALID
      RDF_APIS_USER VALID
      RDF_APIS_INTERNAL VALID
      RDF_APIS VALID
      SDO_RDF_MIG VALID
      RDF_MODELS VALID
      RDF_RULEBASES VALID
      RDF_ALIAS VALID
      RDF_ALIASES VALID
      RDF_VARCHARARRAY VALID
      RDF_LONGVARCHARARRAY VALID
      RDF_MATCH_IMPL_T VALID
      SDO_RDF_TRIPLE VALID
      SDO_RDF_TRIPLE_S VALID
      SDO_RDF_TRIPLE_S VALID
      RDF_MATCH_IMPL_T VALID

      Rmq : rdf_tablespace exist...

      So When i execute this query ....

      Requete : EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tablespace');
      -------

      Error starting at line 1 in command:
      EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tablespace');
      Error report:
      ORA-13199: Error during RDF Network creation: step_num=1 SQLERRM=ORA-00001: violation de contrainte unique (MDSYS.UNIQUE_NETWORK_LAYER)
      ORA-06512: à "MDSYS.SDO_NETWORK_TRIG_INS", ligne 30
      ORA-04088: erreur lors d'exécution du déclencheur 'MDSYS.SDO_NETWORK_TRIG_INS'
      ORA-06512: à "MDSYS.MD", ligne 1723
      ORA-06512: à "MDSYS.MDERR", ligne 17
      ORA-06512: à "MDSYS.SDO_RDF_INTERNAL", ligne 7737
      ORA-06512: à "MDSYS.SDO_RDF", ligne 1089
      ORA-06512: à "MDSYS.SDO_RDF", ligne 1105
      ORA-06512: à "MDSYS.RDF_APIS", ligne 786
      ORA-06512: à ligne 1
      13199. 00000 - "%s"
      *Cause:    This is an internal error.
      *Action:   Contact Oracle Support Services.

      Requete : EXECUTE sem_api.create_sem_model('nci','nci_rdf_data','triple');
      -------

      Error starting at line 1 in command:
      EXECUTE sem_api.create_sem_model('nci','nci_rdf_data','triple');
      Error report:
      ORA-06550: Ligne 1, colonne 7 :
      PLS-00201: l'identificateur 'SEM_API.CREATE_SEM_MODEL' doit être déclaré
      ORA-06550: Ligne 1, colonne 7 :
      PL/SQL: Statement ignored
      06550. 00000 - "line %s, column %s:\n%s"
      *Cause:    Usually a PL/SQL compilation error.
      *Action:

      Can u help me plz ?