Home » Server Options » Spatial » Creating a Spatial Index on LRS data fails
Creating a Spatial Index on LRS data fails [message #75785] Fri, 12 July 2002 02:04 Go to next message
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
Re: Creating a Spatial Index on LRS data fails [message #75786 is a reply to message #75785] Mon, 15 July 2002 10:43 Go to previous message
Raj
Messages: 411
Registered: November 1998
Senior Member
I think the table-definition is not yet registered with SDO_GEOM_METADATA_TABLE, please check it once again.

-Raj
Previous Topic: OCI c++ samples
Next Topic: spatial query in loop gets slower and slower
Goto Forum:
  


Current Time: Thu Mar 28 10:23:46 CDT 2024