This content has been marked as final. Show 3 replies
Yes, that will help, except that the argument passed into DROP_NETWORK has to be 'RDF', not 'rdf_tblspace' (which is the tablespace name). This command has to be executed as someone with dba privileges, the user you used to create the network.
In addition in case you need further cleanup you could try:
-- connect as the MDSYS user before running this script --
DELETE FROM sdo_network_metadata_table WHERE network='RDF';
DROP TABLE RDF_NODE$;
DROP TABLE RDF_LINK$;
DROP TABLE RDF_MODEL$;
DROP TABLE RDF_PATH$;
DROP TABLE RDF_PLINK$;
DROP TABLE RDF_NAMESPACE$;
DROP TABLE RDF_BLANK_NODE$;
DROP TABLE RDF_VALUE$;
DROP SEQUENCE rdf_value_id_sq;
DROP SEQUENCE rdf_node_id_sq;
DROP SEQUENCE rdf_link_id_sq;
DROP SEQUENCE rdf_model_id_sq;
DROP SEQUENCE rdf_namesp_id_sq;
DROP SEQUENCE rdf_long_lit_id_sq;
I wonder why you are in this situation however. Did your very first attempt to create an rdf network using sdo_rdf.create_rdf_network('rdf_tblspace') fail? And does it fail again after the above cleanup when you retry? If so one possibility is that your database does not have partitioning enabled. That is necessary for the RDF functionality.
Thanks. As you said, that it fails again after above clean up. It works.