1 Reply Latest reply on Jun 10, 2008 4:50 PM by alwu-Oracle

    error creating rdf network

    643728
      hi..
      I'm trying to creating rdf network to tablespace, but error. the error message is :

      BEGIN SDO_RDF.CREATE_RDF_NETWORK('music_tblspace'); END;

      *
      ERROR at line 1:
      ORA-55321: network already exists
      ORA-06512: at "MDSYS.MD", line 1723
      ORA-06512: at "MDSYS.MDERR", line 17
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 5296
      ORA-06512: at "MDSYS.SDO_RDF", line 910
      ORA-06512: at line 1

      'music_tblspace' is name of the rdf_network that will be created
      before this, i was created a tablespace, and success. The command is :

      CREATE TABLESPACE music_tblspace
      DATAFILE 'j:\orcl\music_tblspace.dat' SIZE 512M REUSE
      AUTOEXTEND ON NEXT 256M MAXSIZE UNLIMITED
      SEGMENT SPACE MANAGEMENT AUTO;

      I tried to delete the network.. with this command :
      EXEC SDO_NET.DROP_NETWORK('music_tblspace');
      this command success, but when i execute this command (i have read this thread rdf network problem how to delete rdf network) :
      DELETE FROM sdo_network_metadata_table WHERE network='music_tblspace';
      error message is occur :
      DELETE FROM sdo_network_metadata_table WHERE network='music_tblspace'
      *
      ERROR at line 1:
      ORA-00942: table or view does not exist

      I'm using privilage as sys, and i'm connect with mdsys, but still not work..

      - praja -