Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Spatial Index Fails ORA-29875

267925Jan 30 2006 — edited Feb 19 2006
Hello,
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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2006
Added on Jan 30 2006
5 comments
1,842 views