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 FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms