This discussion is archived
1 Reply Latest reply: Mar 10, 2013 1:15 AM by Stefan Jager RSS

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

995202 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points