0 Replies Latest reply on Jul 28, 2008 1:54 PM by 617912

    error creating rdf_network in 10g

    617912
      Hi, I have dropped the rdf_tablespace before dropping the rdf_network. After which, droppig rdf_network is resulting in errors. So, I have read the forums and found a thread where it was suggested to clean up all the tables and sequences. This is what i have followed:

      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;

      Later I reapplied the RDF patch and tried to create the RDF_network. But it is throwing the following error:

      SQL> EXECUTE SDO_RDF.CREATE_RDF_NETWORK('rdf_tablespace');
      BEGIN SDO_RDF.CREATE_RDF_NETWORK('rdf_tablespace'); END;

      *
      ERROR at line 1:
      ORA-02289: sequence does not exist
      ORA-06512: at "MDSYS.SDO_NETWORK_TRIG_INS", line 11
      ORA-04088: error during execution of trigger 'MDSYS.SDO_NETWORK_TRIG_INS'
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 3461
      ORA-06512: at "MDSYS.SDO_RDF", line 204
      ORA-06512: at line 1

      Please help me..

      Thanks,
      Rajesh.