Home » Server Options » Spatial » error creating rdf network (Oracle 11g)
error creating rdf network [message #325660] Sat, 07 June 2008 05:44
praja
Messages: 1
Registered: June 2008
Location: Surabaya
Junior Member

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 http://forums.oracle.com/forums/thread.jspa?threadID=373134&tstart=0, 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 -
Previous Topic: Spatial Extractor for Oracle Spatial
Next Topic: Training Institute
Goto Forum:
  


Current Time: Mon Mar 18 22:10:26 CDT 2024