1 Reply Latest reply: Mar 10, 2013 4:15 AM by Stefan Jager RSS

    ORA-06512: at "MDSYS.SDO_ROUTER_PARTITION", line 1160

    995202
      Hi,

      I am creating router network and getting given below error

      CALL MDSYS.SDO_ROUTER_PARTITION.CREATE_ROUTER_NETWORK ('NAVTEQ_UTIL_RN_Q310.log','NAVTEQ_UTIL_RN_Q310');
      CALL MDSYS.SDO_ROUTER_PARTITION.CREATE_ROUTER_NETWORK ('NAVTEQ_UTIL_RN_Q310.log','NAVTEQ_UTIL_RN_Q310')
      *
      ERROR at line 1:
      ORA-00942: table or view does not exist
      ORA-06512: at "MDSYS.SDO_ROUTER_PARTITION", line 1160
      ORA-06512: at line 1

      I have cheeked in the database . EDGE and Node tables do not exist in the database, can some one pls tell me which package contain these tables so i can create the tables.

      Best Regards,
      Rishi
        • 1. Re: ORA-06512: at "MDSYS.SDO_ROUTER_PARTITION", line 1160
          Stefan Jager
          Hi Unknown,
          SDO_ROUTER_PARTITION.CREATE_ROUTER_NETWORK('<log_file_name>', '<network_name>');
          The function expects a network name, not a table. Allthough it is unclear from the documentation (Oracle?), if I remember correctly you have to create a regular network first, [url http://docs.oracle.com/cd/E11882_01/appdev.112/e11831/sdo_net_concepts.htm#CIHHEDAC]see the Network Modeling documentation.

          HTH,
          Stefan