This discussion is archived
6 Replies Latest reply: Apr 8, 2010 3:13 AM by 638832 RSS

rdf network problem

500764 Newbie
Currently Being Moderated
Hi
im testing rdf suppor in oracle 10 g r2 enterprise edition and
I can't create a rdf network
this is the error.
SQL> execute sdo_rdf.create_rdf_network('rdf_ejemplo');
BEGIN sdo_rdf.create_rdf_network('rdf_ejemplo'); END;

*
ERROR at line 1:
ORA-13199: RDF NETWORK already exists
ORA-06512: en "MDSYS.MD", línea 1723
ORA-06512: en "MDSYS.MDERR", línea 17
ORA-06512: en "MDSYS.SDO_RDF_INTERNAL", línea 2200
ORA-06512: en "MDSYS.SDO_RDF", línea 137
ORA-06512: en línea 1

then i execute this commands

SQL> create table familia_rdf(id number, triple sdo_rdf_triple_s);

Table created.

SQL> execute sdo_rdf.create_rdf_model('family', 'familia_rdf', 'triple');
BEGIN sdo_rdf.create_rdf_model('family', 'familia_rdf', 'triple'); END;

*
ERROR at line 1:
ORA-13199: RDF NETWORK or FAMILIA_RDF does not exist
ORA-06512: en "MDSYS.MD", línea 1723
ORA-06512: en "MDSYS.MDERR", línea 17
ORA-06512: en "MDSYS.SDO_RDF_INTERNAL", línea 1774
ORA-06512: en "MDSYS.SDO_RDF", línea 117
ORA-06512: en línea 1

so i try to create de rdf network but already exists so i try to droped
and i can't.

SQL> execute sdo_rdf.drop_rdf_network;
BEGIN sdo_rdf.drop_rdf_network; END;

*
ERROR at line 1:
ORA-13199: Drop RDF NETWORK error occurred
ORA-06512: en "MDSYS.MD", línea 1723
ORA-06512: en "MDSYS.MDERR", línea 17
ORA-06512: en "MDSYS.SDO_RDF_INTERNAL", línea 2301
ORA-06512: en "MDSYS.SDO_RDF", línea 146
ORA-06512: en línea 1

pleace help, help
thanks
Hi
im testing rdf suppor in oracle 10 g r2 enterprise edition and
I can't create a rdf network
this is the error.
SQL> execute sdo_rdf.create_rdf_network('rdf_ejemplo');
BEGIN sdo_rdf.create_rdf_network('rdf_ejemplo'); END;

*
ERROR at line 1:
ORA-13199: RDF NETWORK already exists
ORA-06512: en "MDSYS.MD", línea 1723
ORA-06512: en "MDSYS.MDERR", línea 17
ORA-06512: en "MDSYS.SDO_RDF_INTERNAL", línea 2200
ORA-06512: en "MDSYS.SDO_RDF", línea 137
ORA-06512: en línea 1

then i execute this commands

SQL> create table familia_rdf(id number, triple sdo_rdf_triple_s);

Table created.

SQL> execute sdo_rdf.create_rdf_model('family', 'familia_rdf', 'triple');
BEGIN sdo_rdf.create_rdf_model('family', 'familia_rdf', 'triple'); END;

*
ERROR at line 1:
ORA-13199: RDF NETWORK or FAMILIA_RDF does not exist
ORA-06512: en "MDSYS.MD", línea 1723
ORA-06512: en "MDSYS.MDERR", línea 17
ORA-06512: en "MDSYS.SDO_RDF_INTERNAL", línea 1774
ORA-06512: en "MDSYS.SDO_RDF", línea 117
ORA-06512: en línea 1

so i try to create de rdf network but already exists so i try to droped
and i can't.

SQL> execute sdo_rdf.drop_rdf_network;
BEGIN sdo_rdf.drop_rdf_network; END;

*
ERROR at line 1:
ORA-13199: Drop RDF NETWORK error occurred
ORA-06512: en "MDSYS.MD", línea 1723
ORA-06512: en "MDSYS.MDERR", línea 17
ORA-06512: en "MDSYS.SDO_RDF_INTERNAL", línea 2301
ORA-06512: en "MDSYS.SDO_RDF", línea 146
ORA-06512: en línea 1

pleace help, help
thanks
caro
  • 1. Re: rdf network problem
    276592 Newbie
    Currently Being Moderated
    Hi,

    To create an RDF network the following should be true - partitioning has to be enabled in the database, the database block size has to be 8K (the default block size during database creation), there should be enough disk space, and the user creating the RDF network has to have DBA privileges. In your case I see from the emails you have sent us that partitioning was not enabled in your database, causing the creation of the RDF network to fail. (I am investigating the different reasons why partitioning is not enabled in your database and will respond to that separately).

    If the RDF network is not created properly for any of the above reasons, 'drop network' might not cleanly drop the RDF network. The following script will have to be manually run to drop the RDF network.

    -- connect as the MDSYS user before running this script --
    EXEC SDO_NET.DROP_NETWORK('RDF');
    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;

    Once you have dropped the network and we have figured out why partitioning is not enabled in your database you can re-create the RDF network and the model.


    Melli
  • 2. Re: rdf network problem
    500764 Newbie
    Currently Being Moderated
    I install the oracle enterprise edition, and know works very good
    know i can create my rdf network whit no problem
    is a cool option for rdf, and it looks easier that rdf/xml
    thanks for the help
    greeting from Chile, south america
    Caro
  • 3. Re: rdf network problem
    553322 Newbie
    Currently Being Moderated
    When I have create the RDF netwok correctly,I inpue"execute sdo_rdf.create_rdf_model('family', 'family_rdf_data', 'triple');".
    the message is:
    ORA-13199: Model error occurred
    ORA-06512: 在 "MDSYS.MD", line 1723
    ORA-06512: 在 "MDSYS.MDERR", line 17
    ORA-06512: 在 "MDSYS.SDO_RDF_INTERNAL", line 1779
    ORA-06512: 在 "MDSYS.SDO_RDF", line 117
    ORA-06512: 在 line 1
    My system is microsoft windows,and I install 10.2.01 for microsoft windows.
    I want to know the reason and the method.
    thankyou!
  • 4. Re: rdf network problem
    563544 Newbie
    Currently Being Moderated
    have you resoved this problem of creating the rdf_model? I am running into the same problem
    Thank you
    ming
  • 5. Re: rdf network problem
    563544 Newbie
    Currently Being Moderated
    Sorry. I am replying to myself, but I have figured it out.
    This error happened because I was creating it as sys.
    According to Oracle document, after creating the network as a privileged user, you should connect as a regular user to create the table and models.
  • 6. Re: rdf network problem
    638832 Newbie
    Currently Being Moderated
    Hello.

    I am trying to create an RDF network. I connect with sys as sysdba to the database and I execute the following:

    EXECUTE SDO_RDF.CREATE_RDF_NETWORK('rdf_tblspace');

    and i get:

    BEGIN SDO_RDF.CREATE_RDF_NETWORK('rdf_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 7726
    ORA-06512: at "MDSYS.SDO_RDF", line 1089
    ORA-06512: at line 1

    After that, when i log in the database with mdsys user and try to create the semantic model, i execute the following:

    SQL> EXECUTE SDO_RDF.CREATE_RDF_MODEL('articles', 'articles_rdf_data', 'triple');
    BEGIN SDO_RDF.CREATE_RDF_MODEL('articles', 'articles_rdf_data', 'triple'); END;

    *
    ERROR at line 1:
    ORA-13199: Tablespace "" does not exist
    ORA-06512: at "MDSYS.MD", line 1723
    ORA-06512: at "MDSYS.MDERR", line 17
    ORA-06512: at "MDSYS.SDO_RDF", line 974
    ORA-06512: at line 1


    Can you please tell me what is the problem?

    Thank you.
    Catalin