Thread: error creating rdf network


Permlink Replies: 1 - Pages: 1 - Last Post: Jun 10, 2008 9:50 AM Last Post By: alwu Threads: [ Previous | Next ]
praja

Posts: 1
Registered: 06/06/08
error creating rdf network
Posted: Jun 6, 2008 11:28 PM
Click to report abuse...   Click to reply to this thread Reply
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 -
alwu

Posts: 324
Registered: 01/10/01
Re: error creating rdf network
Posted: Jun 10, 2008 9:50 AM   in response to: praja in response to: praja
Click to report abuse...   Click to reply to this thread Reply
You should use sdo_rdf.drop_rdf_network API.
Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums