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.