| Creating a Spatial Index on LRS data fails [message #75785] |
Fri, 12 July 2002 02:04  |
Bernhard Schandl
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
Hello board,
i am trying to create an index on a spatial data column. I use the following table:
CREATE TABLE LRS
(
road VARCHAR2(10) PRIMARY KEY,
geom MDSYS.SDO_GEOMETRY
);
and the following metadata definition:
INSERT INTO user_sdo_geom_metadata VALUES
(
'LRS',
'GEOM',
MDSYS.SDO_DIM_ARRAY
(
MDSYS.SDO_DIM_ELEMENT('Longitude', -180, 180, 1),
MDSYS.SDO_DIM_ELEMENT('Latitude', -90, 90, 1),
MDSYS.SDO_DIM_ELEMENT('Measure', 0, 1000000, 1)
),
8307
);
and try to create the index using
CREATE INDEX LRSIDX
ON LRS(geom)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS ('sdo_indx_dims=2');
as described in the documentation. this causes the error message (in german here)
CREATE INDEX LRSIDX
*
FEHLER in Zeile 1:
ORA-29855: Fehler bei Ausführung der Routine ODCIINDEXCREATE
ORA-13236: Interner Fehler bei Verarbeitung von R-Baum: [[specified index dimensionality should be 2 for geodetic layers]]
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_9I", Zeile 7
ORA-06512: in Zeile 1
which is (translated):
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13236: internal error in R-tree processing: [[specified index dimensionality should be 2 for geodetic layers]]
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_9I", line 7
ORA-06512: in line 1
Are there any suggestions what went wrong or what should i do differently? the oracle version is 9.0.1.1.1
thank you for help!
regards bernhard
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
