| 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 -
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
