It is in general a good idea to use BIGFILE tablespace.
create bigfile temporary tablespace bigtmpts tempfile '/your_directory_here/bigtmpts.dat' size 512M reuse autoextend on next 512M maxsize unlimited;
We have experimented with SNOMED ontology and it works fine. Maybe the SNOMED you tried has a different version. If you like, please
contact Oracle Support, file an SR and attach your SNOMED ontology. Let me know if you don't have a support account.
Thanks a lot for the immediate response.
I'll try with a BIGFILE temporary tablespace. Do I have to create any indexes on the triples table before I start the inference?? Does this improve performance or the indexes are constructed by the system anyway?
I'll also fill an SR in case the BIGFILE won't work. My version of SNOMED is an old one (a few years ago).