Cannot create Spatial index in Oracle 11g
701897Apr 14 2010 — edited Apr 14 2010Hi all !
I'm using Oracle 11gR2 on Windows 2008 ( 64bitxR2) . When I receive some errors when I create oracle11g2 Spatial Index but it works well with Oracle 10g . I don't know what I did wrong or do I need a bug fix for Oracle Spatial 11g2 ?
Can you help me out ? Thanks for any help !!!
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-29400: data cartridge error
ORA-01403: no data found
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: [mdpridxtxfergm]
ORA-13200: internal error [ROWID:AAAUmYAAIAAAJuFAAB] in spatial indexering.
ORA-13206: internal error [] while creating the spatial index
ORA-13033: Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object
ORA-06512: vid "MDSYS.SDO_INDEX_METHOD_10I", row 313
DELETE FROM mdsys.sdo_coord_ref_system WHERE srid=50632625;
DELETE FROM mdsys.sdo_coord_op_param_vals WHERE coord_op_id=50632625;
DELETE FROM mdsys.sdo_coord_ops WHERE coord_op_id=50632625;
-- COORD_OP_METHOD_ID=9807: Transverse Mercator
INSERT INTO MDSYS.SDO_COORD_OPS (
COORD_OP_ID, COORD_OP_NAME, COORD_OP_TYPE, COORD_OP_METHOD_ID,
INFORMATION_SOURCE, DATA_SOURCE,
SHOW_OPERATION, IS_LEGACY, REVERSE_OP, IS_IMPLEMENTED_FORWARD, IS_IMPLEMENTED_REVERSE)
values (
50632625, 'ST_74_0_GON_65:-1 op', 'CONVERSION', 9807,
'Digpro AB, coordinatehandler@digpro.se', 'Digpro AB',
1, 'FALSE', 1, 1, 1);
-- Parameter for latitude of origin 0°
INSERT INTO MDSYS.SDO_COORD_OP_PARAM_VALS (
COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID)
VALUES (50632625, 9807, 8801, 0.000000, NULL, 9102);
-- Parameter for central meridian 18° 03' 28.044" east
INSERT INTO MDSYS.SDO_COORD_OP_PARAM_VALS (
COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID)
VALUES (50632625, 9807, 8802, 18.05779, NULL, 9102);
-- Parameter for scale factor
INSERT INTO MDSYS.SDO_COORD_OP_PARAM_VALS (
COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID)
VALUES (50632625, 9807, 8805, 0.99999425, NULL, 9201);
-- Parameter for false easting
INSERT INTO MDSYS.SDO_COORD_OP_PARAM_VALS (
COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID)
VALUES (50632625, 9807, 8806, 100178.1808, NULL, 9001);
-- Parameter for false northing
INSERT INTO MDSYS.SDO_COORD_OP_PARAM_VALS (
COORD_OP_ID, COORD_OP_METHOD_ID, PARAMETER_ID, PARAMETER_VALUE, PARAM_VALUE_FILE_REF, UOM_ID)
VALUES (50632625, 9807, 8807, -6500614.7836, NULL, 9001);
-- Adds the projected system on top of the geodetic system in rt90_dp_geosystem_102.sql
-- COORD_SYS_ID=4400: Cartesian 2D CS. Axes: easting, northing (E,N). Orientations: east, north. UoM: m.
-- GEOG_CRS_DATUM_ID=4619: SWEREF99
INSERT INTO MDSYS.SDO_COORD_REF_SYSTEM (
SRID, COORD_REF_SYS_NAME, COORD_REF_SYS_KIND, COORD_SYS_ID,
DATUM_ID, GEOG_CRS_DATUM_ID, SOURCE_GEOG_SRID, PROJECTION_CONV_ID,
CMPD_HORIZ_SRID,CMPD_VERT_SRID,INFORMATION_SOURCE,
DATA_SOURCE,IS_LEGACY,LEGACY_CODE,LEGACY_WKTEXT,LEGACY_CS_BOUNDS,
IS_VALID,SUPPORTS_SDO_GEOMETRY)
VALUES (
50632625,'ST_74_0_GON_65:-1','PROJECTED',4400,
NULL, 6619, 4619, 50632625,
NULL,NULL,'Digpro AB, coordinatehandler@digpro.se',
'Digpro AB','FALSE',NULL,NULL,NULL,
'TRUE','TRUE');
sqlplus kranskom/password
--Update metadata for KRANSKOM schema
insert into user_sdo_geom_metadata values (
'GRAG', 'SHAPE',
mdsys.sdo_dim_array(
mdsys.sdo_dim_element('Y', -100000, 200000, 0.0005),
mdsys.sdo_dim_element('X', -100000, 200000, 0.0005),
mdsys.sdo_dim_element('Z', -1000, 1000, 0.0005)
),50632625
);
---Display content in SHAPE column (in GRAG table)
Insert into GRAG (SHAPE) values (MDSYS.SDO_GEOMETRY(3003,50632625,'null',MDSYS.SDO_ELEM_INFO_ARRAY(1,5,1,1,2,1),MDSYS.SDO_ORDINATE_ARRAY(276.2339,-179.7433,0,276.2498,-179.7361,0,276.2668,-179.7324,0,276.2842,-179.7325,0,276.6235,-179.7691,0,276.793,-179.7731,0,276.8055,-179.772,0,276.8174,-179.7682,0,276.8281,-179.7619,0,277.073,-179.5793,0,277.2068,-179.4543,0,277.2122,-179.4481,0,277.2162,-179.4408,0,277.2186,-179.4329,0,277.2192,-179.4247,0,277.2159,-179.3107,0,277.3184,-178.9335,0,277.3252,-178.6913,0,277.3265,-178.5765,0,277.3258,-178.5683,0,277.3237,-178.5604,0,277.3201,-178.5531,0,277.3152,-178.5465,0,277.3092,-178.541,0,277.3023,-178.5366,0,277.2947,-178.5337,0,277.2867,-178.5321,0,277.1778,-178.5219,0,277.1731,-178.5219,0,277.1683,-178.5227,0,277.1637,-178.5244,0,277.1595,-178.5268,0,277.1558,-178.5299,0,277.1527,-178.5336,0,277.1503,-178.5378,0,277.1486,-178.5424,0,277.1478,-178.5471,0,277.1478,-178.5519,0,277.1536,-178.6151,0,277.1537,-178.6198,0,277.1529,-178.6244,0,277.1515,-178.6289,0,277.0012,-178.9885,0,276.9919,-179.0066,0,276.9797,-179.023,0,276.9651,-179.0373,0,276.2832,-179.6059,0,276.2804,-179.6079,0,276.2773,-179.6093,0,276.274,-179.6101,0,276.2706,-179.6103,0,276.2673,-179.61,0,276.264,-179.609,0,276.2609,-179.6075,0,276.2582,-179.6054,0,276.2559,-179.6029,0,276.2541,-179.6001,0,276.2528,-179.5969,0,276.252,-179.5935,0,276.2476,-179.5581,0,276.247,-179.5555,0,276.2459,-179.5529,0,276.2444,-179.5506,0,276.2425,-179.5485,0,276.2402,-179.5469,0,276.2377,-179.5456,0,276.235,-179.5449,0,276.2322,-179.5446,0,276.2294,-179.5449,0,276.2267,-179.5456,0,276.2242,-179.5468,0,276.2219,-179.5485,0,276.22,-179.5505,0,276.0132,-179.8127,0,276.0105,-179.8169,0,276.0086,-179.8215,0,276.0076,-179.8263,0,276.0074,-179.8312,0,276.0082,-179.8361,0,276.0099,-179.8408,0,276.0124,-179.845,0,276.0157,-179.8488,0,276.0196,-179.8518,0,276.0239,-179.8541,0,276.0287,-179.8556,0,276.0336,-179.8562,0,276.0385,-179.8558,0,276.0433,-179.8546,0,276.0478,-179.8525,0,276.2339,-179.7433,0)));