SEM_MATCH Query Errors Out With ORA-20000 We Do Not Have A Rules Index For This Model-Rulebase Combination (Doc ID 1598993.1)

Last updated on APRIL 01, 2020

Applies to:

Symptoms

SEM_MATCH Query Errors Out With ORA-20000: We Do Not Have a Rules Index For This Model-Rulebase Combination

Select m
from table (sem_match(
'(?m rdf:type :Male)',
SDO_RDF_Models('person'),
SDO_RDF_Rulebases ('RDFS','person_rb'),
SDO_RDF_Aliases(SDO_RDF_ALIAS('', 'http://FamilyPerson/person/')),
null));

--error
ORA-20000: We do not have a rules index for this Model-Rulebase combination
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 1119
ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T",line 387
ORA-06512: at line 1

although we have already created

-- RDFS inferencing in the person model (create inference rules) ----- successful!
execute sem_apis.drop_entailment('rdfs_rix_person');
 
BEGIN
SEM_APIS.CREATE_ENTAILMENT(
 'rdfs_rix_person',
 SEM_Models('person'),
 SEM_Rulebases('RDFS', 'person_rb'));
END;
/

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.