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!

Cannot create Spatial index in Oracle 11g

701897Apr 14 2010 — edited Apr 14 2010
Hi 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)));
This post has been answered by Siva Ravada-Oracle on Apr 14 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 12 2010
Added on Apr 14 2010
6 comments
2,512 views