Database Software

Hello,

I'm trying to partitioning my network. For that I've created a directory and set the permissions.

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

Everything's seems fine. But every time I execute the following procedure I've got an exception (after 3 hours).

execute sdo_router_partition.partition_router('NODE_PART', 4000);

'ORA-00932: inconsistent datatypes: expected UDT got NUMBER'

I'm using Oracle Enterprise Edition 11.1.0.7 in Intel Xeon X5550 2,67GHz 17GB RAM

The log file:

Jue Dic 16 12:20:22 2010
******* Beginning SDO Router partitioning
Jue Dic 16 12:20:22 2010
INFO: create and load node_part table
Jue Dic 16 12:21:36 2010
******* Beginning SDO Router partitioning
Jue Dic 16 12:21:36 2010
INFO: create and load node_part table
Jue Dic 16 12:22:8 2010
INFO: cleanup partitioning temporary tables
Jue Dic 16 12:22:23 2010
INFO: begin partitioning of NODE_PART partition level: 10 min(partition id): 0 max(partition id): 0
INFO: generating 2048 partitions from level:0 to level: 10 ...
Jue Dic 16 12:27:22 2010
INFO: partitioning NODE_PART level: 0 partition id: 1
INFO: partitioning level: 0 with 2 partitions took 4.983 min.
Jue Dic 16 12:32:41 2010
INFO: partitioning NODE_PART level: 1 partition id: 3
INFO: partitioning level: 1 with 4 partitions took 5.317 min.
Jue Dic 16 12:37:22 2010
INFO: partitioning NODE_PART level: 2 partition id: 7
INFO: partitioning level: 2 with 8 partitions took 4.683 min.
Jue Dic 16 12:42:23 2010
INFO: partitioning NODE_PART level: 3 partition id: 15
INFO: partitioning level: 3 with 16 partitions took 5.017 min.
Jue Dic 16 12:47:33 2010
INFO: partitioning NODE_PART level: 4 partition id: 31
INFO: partitioning level: 4 with 32 partitions took 5.167 min.
Jue Dic 16 12:53:23 2010
INFO: partitioning NODE_PART level: 5 partition id: 63
INFO: partitioning level: 5 with 64 partitions took 5.833 min.
Jue Dic 16 12:59:54 2010
INFO: partitioning NODE_PART level: 6 partition id: 127
INFO: partitioning level: 6 with 128 partitions took 6.517 min.
Jue Dic 16 13:6:44 2010
INFO: partitioning NODE_PART level: 7 partition id: 255
INFO: partitioning level: 7 with 256 partitions took 6.833 min.
Jue Dic 16 13:15:37 2010
INFO: partitioning NODE_PART level: 8 partition id: 511
INFO: partitioning level: 8 with 512 partitions took 8.900 min.
Jue Dic 16 13:27:50 2010
INFO: partitioning NODE_PART level: 9 partition id: 1023
INFO: partitioning level: 9 with 1024 partitions took 12.217 min.
Jue Dic 16 13:41:39 2010
INFO: partitioning NODE_PART level: 10 partition id: 2047
INFO: partitioning level: 10 with 2048 partitions took 13.800 min.
Jue Dic 16 13:42:13 2010
INFO: completed partitioning of NODE_PART
Jue Dic 16 13:42:13 2010
INFO: create index np_v_idx on node_part
Jue Dic 16 13:42:29 2010
INFO: create and load edge_part
Jue Dic 16 13:49:45 2010
INFO: create index edge_part_s_idx on edge_part
Jue Dic 16 13:52:15 2010
INFO: create index edge_part_t_idx on edge_part
Jue Dic 16 13:53:22 2010
INFO: create index edge_part_st_p_idx on edge_part
Jue Dic 16 13:54:21 2010
INFO: create and load outedge and inedge columns in node_part table
Jue Dic 16 14:57:28 2010
INFO: create index node_part_p_idx on node_part
Jue Dic 16 14:57:52 2010
INFO: recreating node table with partitioning information

The created tables are: EDGE_PART, FINAL_PARTITION, NODE_PART, NODE_TMP, PARTITION_TMP_2 and PARTITION_TMP_3 (but when it crashed, my NODE table appears without data)

The definition of my tables are the following:

CREATE TABLE "XXXX"."EDGE"
( "EDGE_ID" NUMBER(38,0),
"START_NODE_ID" NUMBER(38,0),
"END_NODE_ID" NUMBER(38,0),
"PARTITION_ID" NUMBER(38,0),
"FUNC_CLASS" NUMBER(38,0),
"LENGTH" NUMBER,
"SPEED_LIMIT" NUMBER,
"NAME" VARCHAR2(100 BYTE),
"DIVIDER" VARCHAR2(1 BYTE),
"GEOMETRY" "MDSYS"."SDO_GEOMETRY"
) ;

CREATE INDEX "XXXX"."IDX_EDGE_GEOM" ON "XXXX"."EDGE" ("GEOMETRY")
INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" ;


CREATE TABLE "XXXX"."NODE"
( "NODE_ID" NUMBER,
"PARTITION_ID" NUMBER,
"GEOMETRY" "MDSYS"."SDO_GEOMETRY"
);
CREATE INDEX "XXXX"."IDX_NODE_GEOM" ON "XXXX"."NODE" ("GEOMETRY")
INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" ;



CREATE TABLE "XXXX"."SIGN_POST"
( "MULTINET_JNCTID" NUMBER,
"FROM_EDGE_ID" NUMBER,
"TO_EDGE_ID" NUMBER,
"RAMP" VARCHAR2(64 BYTE),
"EXIT" VARCHAR2(20 BYTE),
"TOWARD" VARCHAR2(128 BYTE)
);

Does anybody know what it is wrong?

Thanks in advance. Best regards