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!

internal error when runnning RECTIFY

701897Apr 16 2010 — edited Apr 16 2010
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2010
Added on Apr 16 2010
4 comments
1,660 views