3 Replies Latest reply on Sep 1, 2009 4:21 PM by Sdas-Oracle

    ALTER_SEM_INDEX_ON_MODEL not found

    671085
      Hi

      I am trying to create semantic indexes. I am able to call "add_sem_index", but the call to "ALTER_SEM_INDEX_ON_MODEL" fails by saying "the component must be declared". I have upgraded from 11.1.0.6 to 11.1.0.7; is there something I missed while upgrading ?

      Another question : which kind of semantic indexes are generally recommended, and are the most useful ?

      Thanks
      Thomas


      SQL> execute sem_apis.drop_sem_index('pso');
      BEGIN sem_apis.drop_sem_index('pso'); END;

      *
      ERREUR Ó la ligne 1 :
      ORA-13199: SQLERRM=ORA-01418: l'index indiquÚ n'existe pas dss=DROP INDEX
      RDF_LNK_PSO_IDX
      ORA-06512: Ó "MDSYS.MD", ligne 1723
      ORA-06512: Ó "MDSYS.MDERR", ligne 17
      ORA-06512: Ó "MDSYS.SDO_RDF_INTERNAL", ligne 8189
      ORA-06512: Ó "MDSYS.SDO_RDF", ligne 1420
      ORA-06512: Ó "MDSYS.RDF_APIS", ligne 1137
      ORA-06512: Ó ligne 1


      SQL> execute sem_apis.add_sem_index('pso');

      ProcÚdure PL/SQL terminÚe avec succÞs.

      SQL> execute sem_apis.alter_sem_index_on_model('rdf_model','pso','rebuild');
      BEGIN sem_apis.alter_sem_index_on_model('rdf_model','pso','rebuild'); END;

      *
      ERREUR Ó la ligne 1 :
      ORA-06550: Ligne 1, colonne 16 :
      PLS-00302: Le composant 'ALTER_SEM_INDEX_ON_MODEL' doit Ûtre dÚclarÚ
      ORA-06550: Ligne 1, colonne 7 :
      PL/SQL: Statement ignored

      Thanks
      Thomas