CREATE_ENTAILMENT Generates Error ORA-01688: unable to extend table MDSYS.RDF#9 partition P_6991854658123038539 by 8192 in tablespace RDF_TBLSPACE (Doc ID 2016559.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

The creation of an entailment is consuming too much temp space and it runs out of space after some time. The temp space available is 800GB which should be enough to create the entailment.

This happens when executing in sqlplus the sem_apis.create_entailment procedure in an Oracle 12.1.0.2.0 Database


WHAT IS FAILING:
----------------

EXECUTE sem_apis.create_entailment('provgen_idx',sem_models('provgen'),sem_rulebases('owlprime'));

ERROR:
------
ERROR at line 1:
ORA-01688: unable to extend table MDSYS.RDF#9 partition P_6991854658123038539
by 8192 in tablespace RDF_TBLSPACE
ORA-06512: at "MDSYS.SDO_SEM_INF_INTERNAL", line 16453
ORA-06512: at "MDSYS.SDO_SEM_INFERENCE", line 302
ORA-06512: at "MDSYS.SDO_SEM_INFERENCE", line 352
ORA-06512: at "MDSYS.RDF_APIS", line 126
ORA-06512: at line 1

STEPS:
------
The issue can be reproduced with the following steps:
1. Load RDF data
2. Create Entailment

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