6 Replies Latest reply: Apr 8, 2010 5:13 AM by 638832 RSS

    rdf network problem

    500764
      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
          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
            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
              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
                MingMendonca2
                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
                  MingMendonca2
                  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
                    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