1 Reply Latest reply on Jun 25, 2007 7:17 PM by Mannamal-Oracle

    Problem creating rule index

    584499
      we are having problems creating index rules in a rdf model,
      we have 2 rules in the table MDSYS.RDFR_test_rb
      in the test model we have at least 3 millions of triplets, now, when we execute
      the following procedure to create the index, it never ends.
      I mean, we ran this script for 30 hs and we had to kill it.

      BEGIN
      SDO_RDF_INFERENCE.CREATE_RULES_INDEX(
      'rdfs_rixt_test',
      SDO_RDF_Models('test'),
      SDO_RDF_Rulebases('RDFS','test_rb'));
      END;
      /

      Oracle Version:

      Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
      PL/SQL Release 10.2.0.3.0 - Production
      CORE     10.2.0.3.0     Production
      TNS for HPUX: Version 10.2.0.3.0 - Production
      NLSRTL Version 10.2.0.3.0 - Production

      do you have any clue?
      thanks