We have two databases. One for testing and another with some more data.
- When we try to create the index in testing, it works.
- When we try to create the index in the environment with more data, we get the following error
SQL> CREATE INDEX IDX_GPOT_BUILDING ON GPOT_BUILDING(POSITION) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL PARAMETERS('SDO_INDX_DIMS=2,LAYER_GTYPE=POINT');
CREATE INDEX IDX_GPOT_BUILDING ON GPOT_BUILDING(POSITION) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARALLEL PARAMETERS('SDO_INDX_DIMS=2,LAYER_GTYPE=POINT')
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13249: Error in spatial index: [mdrcrtxfergm]
ORA-13249: Error in spatial index: [mdpridxtxfer]
ORA-29400: data cartridge error
ORA-12801: error signaled in parallel query server P014, instance
dg***d02.intranet.******.com:ZE**F2 (2)
ORA-13249: Error in spatial index: [mdpridxtxfergm]
ORA-29400: data cartridge error
ORA-01426: numeric overflow
ORA-06512: at "MDSYS.SDO_PRIDX", line 353
ORA-06512: at "MDSYS.SDO_PRIDX", line 342
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10
Any clues about that?
Edited by: usersp on Aug 30, 2012 10:24 AM