Oracle Spatial 11g SDO_ROUTER_PARTITION.partition_router

 Hello,

I have installed Oracle Enterprise Edition v11.1.0.7.0 on Windows Server 2003 OS.

I want to populate PARTITION table of Oracle Routing Data Model using SDO_ROUTER_PARTITION.partition_router PL/SQL procedure. EDGE table has 1.675.478 records, NODE 760.968 records, and SIGN_POST 993 records

Firs of all, I give permissions to my user (TAROUTING) and SYSTEM to write the log file:

  CREATE DIRECTORY sdo_router_log_dir as 'G:\'; 

  GRANT read, write ON DIRECTORY sdo_router_log_dir TO TAROUTING;
  call dbms_java.grant_permission('TAROUTING', 'java.io.FilePermission','G:\*', 'read,write');
  GRANT read, write ON DIRECTORY sdo_router_log_dir TO MDSYS;