2 Replies Latest reply on Oct 27, 2010 6:40 PM by Sdas-Oracle

    SEM_APIS.ADD_SEM_INDEX

    792262
      Hi,

      I am trying to execute the script (With DBA privilege)

      EXECUTE SEM_APIS.ADD_SEM_INDEX('pscm');

      but i am getting the following error

      SQL> show user
      USER is "SYS"

      EXECUTE SEM_APIS.ADD_SEM_INDEX('pscm'); SQL>
      BEGIN SEM_APIS.ADD_SEM_INDEX('pscm'); END;

      *
      ERROR at line 1:
      ORA-13199: Failed in index addition call:ORA-00936: missing expression code=PSCM dss=
      CREATE INDEX "RDF_LNK_PSCM_IDX"
      ON "RDF_LINK$"
      (P_VALUE_ID,START_NODE_ID,CANON_END_NODE_ID,) NOLOGGING LOCAL UNUSABLE ORA-06512: at "MDSYS.SDO_RDF_INTERNAL";, line 8136
      ORA-06512: at "MDSYS.MD";, line 1723
      ORA-06512: at "MDSYS.MDERR";, line 17
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL";, line 8140
      ORA-06512: at "MDSYS.SDO_RDF";, line 1407
      ORA-06512: at "MDSYS.RDF_APIS";, line 1130
      ORA-06512: at line 1

      SQL> exec sem_apis.add_sem_index('SPC');
      BEGIN sem_apis.add_sem_index('SPC'); END;

      *
      ERROR at line 1:
      ORA-13199: Failed in index addition call:ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired code=SPC dss=
      CREATE INDEX "RDF_LNK_SPC_IDX"
      ON "RDF_LINK$"
      (START_NODE_ID,P_VALUE_ID,CANON_END_NODE_ID) COMPRESS 1 NOLOGGING LOCAL UNUSABLE ORA-06512: at "MDSYS.SDO_RDF_INTERNAL";, line 8136
      ORA-06512: at "MDSYS.MD";, line 1723
      ORA-06512: at "MDSYS.MDERR";, line 17
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL";, line 8140
      ORA-06512: at "MDSYS.SDO_RDF";, line 1407
      ORA-06512: at "MDSYS.RDF_APIS";, line 1130
      ORA-06512: at line 1


      Help me how to resolve this error and i am using Oracle Database 11g Enterprise Edition Release 11.1.0.7.0

      Please let me know if more details required.

      Regards,
      Kavitha.