1 Reply Latest reply on Oct 27, 2010 5:59 PM by alwu-Oracle

    Unable to create the Rule Index (SEM_APIS.CREATE_RULES_INDEX) getting error

    792262
      Hi,

      I am trying to create the Rule Index with the below script its giving the temp table space error.

      The number of records in that specific table is 17473708 (17+ M) and the available temp space is 120GB.

      Execute SEM_APIS.CREATE_RULEBASE('ecc_md_rb')

      --Insert to mdsys.semr_ecc_md_rb Values(.............)

      BEGIN
      SEM_APIS.CREATE_RULES_INDEX(
      'ecc_rule_indx',
      SEM_Models('FOUNDATION'),
      SEM_Rulebases('RDFS','ecc_dm_rb'));
      END;

      Create rule index statement is running more than 8hrs and i tried with the sem_apis.create_entailment its also giving the same Temp table space error.

      Please find the below error details

      BEGIN sem_apis.create_entailment('ecc_rule_inx', sem_models('FOUNDATION'), sem_rulebases('OWLPRIME','ecc_dm_rb'),SEM_APIS.REACH_CLOSURE,'RDFS2-, RDFS3-, RDFS4a-, RDFS4b-, RDFS5-, RDFS6-, RDFS7-, RDFS8-, RDFS9-, RDFS10-, RDFS11-, RDFS12-, RDFS13-','USER_RULES=T'); END;
      Error at line 1
      ORA-29532: Java call terminated by uncaught Java exception: oracle.jdbc.driver.OracleSQLException: ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
      ORA-06512: at "MDSYS.SDO_SEM_INFERENCE";, line 4866
      ORA-06512: at "MDSYS.RDF_APIS";, line 16
      ORA-06512: at line 1


      Please Help me to create rule index.


      Note: I am using Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production


      Regards,
      Kavitha.