I have created a semantic network using a tablespace called 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!