Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

creation of rules index failing with ORA-01652 exception

653373Aug 4 2008 — edited Aug 5 2008
I am trying to create a rules index in the following way,

BEGIN
SEM_APIS.CREATE_RULES_INDEX(
'APPS_RDF_IDX',
SEM_Models('SEMANTIC_SEARCH_MODEL'),
SEM_Rulebases('OWLPRIME','SEMANTIC_SEARCH_RULEBASE'));
END;

with semantic_search_rulebase having about 5 rules and with 28839 triples in the model.

When I am trying to run create index it fails after a long time by throwing exception

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

though TEMP is allocated 5GB memory.

Please clarify me on the following questions,

1. How much TEMP space should be allocated if the triples are going to be in millions and rules at about 10 to 100 and why is indexing taking a lot of TEMP space with a less amount of triples.

2. How much time normally would create rules index take with triples of size from thousands to millions.

3. How to make the create rules index run faster.

Thanks,
Phani

Comments

Sdas-Oracle
Answer

Hi Fred,

The problem you are seeing seems to be an RDBMS (tablespace) issue, not an RDF issue. The error is being raised during processing of an INSERT /*+ APPEND */ statement issue by bulk-load to append the current batch of input triples (in id-based form) into the table partition designated for the RDF model.

If you'd like, you can contact me by email: souripriya dot das at oracle dot com.

Thanks,

- Souri.

Marked as Answer by 3054700 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 2 2008
Added on Aug 4 2008
3 comments
2,128 views