Dear all,

I have created a semantic network using a tablespace called rdf_users:

EXECUTE SEM_APIS.CREATE_SEM_NETWORK('RDF_USERS');

In this semantic network I have two semantic models, i.e with two triples tables to store references (rdf_data_1 and rdf_data_2):

EXECUTE SEM_APIS.CREATE_SEM_MODEL('model1', 'rdf_data_1', 'triple');
EXECUTE SEM_APIS.CREATE_SEM_MODEL('model2', 'rdf_data_2', 'triple');

I then loaded triples in the model (from a relational database, i.e creating virtual models, exporting them into a staging table with SEM_APIS.EXPORT_RDFVIEW_MODEL and bulk loading from the staging table to the semantic model with SEM_APIS.BULK_LOAD_FROM_STAGING_TABLE)

The rdf_users tablespace grew up to 170G.

Now I deleted one model (both models contain approximately the same volume of data):

BEGIN
 SEM_APIS.DROP_RDFVIEW_MODEL(model_name => 'model2');
END;
DROP TABLE rdf_data_2 PURGE;

At that point I want to generate a third model model3, but I'm having the following issue when triples are loaded into the model from a staging table (Note that they are not loaded all at once but in smaller batches):

BEGIN
 SEM_APIS.BULK_LOAD_FROM_STAGING_TABLE('model3','username','STAGE_TABLE');
END;
(error) DBD::Oracle::db do failed: ORA-13199:  MRG1opt failed: error stack:
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO01'

[
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 6239

]
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 6279
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 7873
ORA-06512: at "MDSYS.SDO_RDF", line 1014
ORA-06512: at "MDSYS.RDF_APIS", line 926
ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute)

Indeed my HD is full (100% used!)

But checking free space in the tablespaces I see than undo tablespace is 100% free (checked using this query) but bulk loading still tries to extend it.

Tablespace Used(MB) Free(MB) Total(MB) Free(%)
SYSAUX         5019      321      5340       6
USERS             1    32725     32726     100
USERS1        10102    11850     21952      54
UNDO01           40    98911     98951     100
SYSTEM          871        9       880       1
RDF_USERS     79563    94295    173858      54

I also tried to resize RDF_USERS, but couln't:

ALTER TABLESPACE RDF_USERS RESIZE 150G
Error report -
SQL Error: ORA-03297: file contains used data beyond requested RESIZE value

I'm not sure it is a RDF related issue, or what I am missing, but I can not figure out how to generate a new model (actually replace one, since I'm trying to remove a model before recreating it) since it seems to always need to extend tablespaces!

Any help appreciated!

Thanks

Fred