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