Error creating index on RDF model
681909Apr 14 2010 — edited Apr 16 2010I am running the create index as shown in 1.9 of the Semantic Developers Guide. I have 4 Oracle semantic models. All of our access is via sparql, with most of the 'WHERE' logic focused on the object part of the triples. We do a lot of querying on specific value and a lot of REGEX, primarily on the object values. So, it seems to me to be a good idea to build an index on the object part of the triples. However, this:
create index POINT_OBJ_IDX on POINT (TO_CHAR(TRIPLE.GET_OBJECT())) throws this error:
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual:
4223, maximum: 4000)
Of the 4 models, 2 the index create works fine and the other 2 throw the error.
Is there any way I can query the model or inspect using some other method that will show me which triple(s) are causing this error when building the index?