Spatial Index Fails ORA-29875
267925Jan 30 2006 — edited Feb 19 2006Hello,
I have a partitioned spatial table with a partioned index. The geometry contains X,Y and M values with the following MetaData:
INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES ('NHPN_ROUTE', 'SHAPE',
MDSYS.SDO_DIM_ARRAY
(MDSYS.SDO_DIM_ELEMENT('X', -178.75, -64.50, 0.0000005),
MDSYS.SDO_DIM_ELEMENT('Y', 17.0, 71.70, 0.0000005),
MDSYS.SDO_DIM_ELEMENT('M', 0, 2000, 0.0000005)),
NULL);
When I do a select into this table from a staging area table it returns the following error:
ERROR at line 1:
ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-00600: internal error code, arguments: [kcbgtcr_4], [61605], [0], [1], [],
[], [], []
The table is created like this:
CREATE TABLE MY_ROUTE(
OBJECTID NUMBER(38) NOT NULL PRIMARY KEY,
MY_LRSKEY VARCHAR2(60),
MY_STFIPS NUMBER(4),
MY_YEAR NUMBER(4),
SHAPE SDO_GEOMETRY)
TABLESPACE GISDATA
PARTITION BY RANGE(MY_STFIPS)
(PARTITION MY_ROUTE_1 VALUES LESS THAN(2),
etc...)
The index is created like this:
CREATE INDEX MY_ROUTE_S_IDX ON MY_ROUTE(SHAPE)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS ('TABLESPACE=GISINDEX SDO_COMMIT_INTERVAL=1000')
LOCAL(PARTITION MY_ROUTE_1_IDX,
etc...)
The real odd thing is that If I do individual sekect into statements using a where such as MY_STFIPS = 1 then it works fine. I'd have to go through each MY_STFIPS.
Oracle 10g 10.1.4.0
Win Server 2003
Thanks!