internal error when runnning RECTIFY
701897Apr 16 2010 — edited Apr 16 2010I cannot create Spatial Index for this GRAO table.
I know that there's something wrong with data in SDO_ELEM_INFO_ARRAY.
So I run VALIDATE to check if my geometry is valid and
--Displays content in meta_data_view
Insert into GRAO_META (TABLE_NAME,COLUMN_NAME,DIMINFO,SRID) values ('GRAO','SHAPE','MDSYS.SDO_DIM_ELEMENT(MDSYS.SDO_DIM_ELEMENT(Y,-100000,300000,0.0005),MDSYS.SDO_DIM_ELEMENT(X,-100000,300000,0.0005),MDSYS.SDO_DIM_ELEMENT(Z,-1000,2300,0.0005))',50632625);
--Displays content of SHAPE column (in GRAO table )
MDSYS.SDO_GEOMETRY(3003,50632625,null,MDSYS.SDO_ELEM_INFO_ARRAY(1,5,1,1,2,1),MDSYS.SDO_ORDINATE_ARRAY(91191.553635,86242.0279,0,91218.064642,86344.115106,0,91039.701612,86391.135332,0,91017.989571,86307.529311,0,91069.033033,86293.938342,0,91084.642628,86352.774184,0,91084.761819,86353.002877,0,91084.885056,86353.229311,0,91085.012149,86353.453676,0,91085.143193,86353.675784,0,91085.278094,86353.895539,0,91085.416852,86354.112848,0,91085.559279,86354.327806,0,91085.705469,86354.540224,0,91085.855422,86354.750007,0,91086.00895,86354.957157,0,91086.166053,86355.161673,0,91086.32673,86355.363272,0,91086.490888,86355.562143,0,91086.658527,86355.758098,0,91086.829552,86355.951136,0,91087.00387,86356.14107,0,91087.181481,86356.327994,0,91087.362384,86356.511814,0,91087.546391,86356.69234,0,91087.733597,86356.869763,0,91087.923814,86357.043799,0,91088.117135,86357.214542,0,91088.313278,86357.381804,0,91088.512337,86357.54568,0,91088.714312,86357.706075,0,91088.919016,86357.862896,0,91089.126354,86358.016141,0,91089.33642,86358.165718,0,91089.549025,86358.311531,0,91089.764171,86358.45377,0,91089.981763,86358.592152,0,91090.201707,86358.726677,0,91090.424002,86358.857345,0,91090.648461,86358.984156,0,91090.875178,86359.107016,0,91091.103964,86359.225925,0,91091.33482,86359.340882,0,91091.567652,86359.451701,0,91091.802365,86359.558474,0,91092.03896,86359.661108,0,91092.277247,86359.759603,0,91092.517229,86359.853864,0,91092.758809,86359.943987,0,91093.001989,86360.029876,0,91093.24658,86360.111531,0,91093.492487,86360.18886,0,91093.739806,86360.261955,0,91093.988348,86360.330722,0,91094.238019,86360.395069,0,91094.488818,86360.455087,0,91094.740559,86360.510685,0,91094.993334,86360.561861,0,91095.246862,86360.608709,0,91095.353447,86360.626959,0,91161.654011,86343.604194,0,91156.208009,86322.288954,0,91108.2653,86334.598361,0,91108.200107,86334.637308,0,91108.134162,86334.675031,0,91108.067652,86334.71172,0,91108.000484,86334.747091,0,91107.932751,86334.781428,0,91107.864359,86334.814448,0,91107.795498,86334.846339,0,91107.725977,86334.877007,0,91107.655987,86334.906451,0,91107.585526,86334.934674,0,91107.514501,86334.961673,0,91107.443099,86334.987449,0,91107.371227,86335.012002,0,91107.298884,86335.035238,0,91107.226166,86335.057157,0,91107.153165,86335.077853,0,91107.079693,86335.097326,0,91107.006034,86335.115483,0,91106.931904,86335.132322,0,91106.857586,86335.147844,0,91106.782986,86335.162143,0,91106.708198,86335.175125,0,91106.633127,86335.18679,0,91106.557962,86335.197044,0,91106.482516,86335.206075,0,91106.406975,86335.213789,0,91106.33134,86335.220186,0,91106.255517,86335.225266,0,91106.179693,86335.229029,0,91106.103776,86335.231381,0,91106.027859,86335.23251,0,91105.951942,86335.232228,0,91105.876025,86335.230722,0,91105.800107,86335.227806,0,91105.724284,86335.223573,0,91105.648555,86335.218117,0,91105.57292,86335.211249,0,91105.497379,86335.203065,0,91105.422026,86335.193563,0,91105.346862,86335.182745,0,91105.271885,86335.170704,0,91105.197191,86335.157251,0,91105.122685,86335.142482,0,91105.048461,86335.126489,0,91104.974519,86335.10918,0,91104.90086,86335.090553,0,91104.827577,86335.070704,0,91104.75467,86335.049537,0,91104.682139,86335.027148,0,91104.609985,86335.003441,0,91104.538207,86334.978512,0,91104.466993,86334.952265,0,91104.396156,86334.92489,0,91104.325789,86334.896197,0,91104.255987,86334.866282,0,91104.186749,86334.835238,0,91104.117981,86334.802877,0,91104.049872,86334.769387,0,91103.982327,86334.734674,0,91103.915347,86334.698832,0,91103.849025,86334.661861,0,91103.783362,86334.623667,0,91103.718452,86334.584344,0,91103.654105,86334.543893,0,91103.590606,86334.502312,0,91103.527765,86334.459697,0,91103.465676,86334.415953,0,91103.404435,86334.37108,0,91103.343851,86334.325266,0,91103.284209,86334.278324,0,91103.225319,86334.230346,0,91103.167276,86334.181334,0,91103.110173,86334.131287,0,91103.053823,86334.080299,0,91102.998508,86334.028371,0,91102.94404,86333.975501,0,91102.890512,86333.921597,0,91102.837925,86333.866847,0,91102.786279,86333.811061,0,91102.735667,86333.754523,0,91102.685996,86333.697044,0,91102.63736,86333.638719,0,91102.589759,86333.579547,0,91102.543193,86333.519528,0,91102.497661,86333.458756,0,91102.453259,86333.397232,0,91102.409891,86333.334862,0,91102.367558,86333.271738,0,91102.326448,86333.207957,0,91102.286373,86333.143422,0,91102.247426,86333.078229,0,91102.209703,86333.012378,0,91102.173108,86332.945774,0,91102.137643,86332.878606,0,91102.111772,86332.827806,0,91090.292393,86288.277759,0,91142.865394,86274.279641,0,91138.754294,86255.48632,0,91191.553635,86242.0279,0))
-- Display the result after running VALIDATE
SELECT c.dp_oid, SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(c.shape, 0.0005)
FROM GRAO c
DP_OID SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT
1 54668
2 54668
3 54668
... .....
n 54668
P/s I don't know what number (54668) means
-- Display the result after running RECTIFY
SELECT SDO_UTIL.RECTIFY_GEOMETRY(shape, 0.0005)
FROM grao
ORA-13199: the given geometry cannot be rectified
Cause : This is internal error
Action : Contact Oracle support
Vendor code 13199 Error at line 1
How can I solve this problem ??
Thanks for any help