3 Replies Latest reply on Jun 26, 2007 5:41 AM by 479833

    create rdf_network and drop it

    479833
      Hi,
      When I'm trying to create rdf network for a table space I get an error message that
      "RDF NETWORK already exists"
      However when I'm trying to drop the rdf network as the following
      "EXECUTE SDO_RDF.DROP_RDF_NETWORK;"
      I again get an error message as
      "ORA-13199: Drop RDF NETWORK error occurred"

      What can the problem be?

      Thanks for your help
        • 1. Re: create rdf_network and drop it
          556961
          try with:

          EXEC SDO_NET.DROP_NETWORK('rdf_tblspace');
          • 2. Re: create rdf_network and drop it
            Mannamal-Oracle
            EXEC SDO_NET.DROP_NETWORK('RDF');

            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.

            Melli
            • 3. Re: create rdf_network and drop it
              479833
              Thanks. As you said, that it fails again after above clean up. It works.