我有一个表 floating_options，我想列出 area_geo(这是一个sdo_geometry列，有两行数据，当我从5 u( d, Y4 z/ V
floating_options中选择创建空间索引时出现)。 9 X. h x3 [' L c, U I我使用了以下代码，但我收到了以下错误。非常感谢您的帮助！谢谢！ 4 L& o2 p5 B' @. C" g' g# N" \2 aCREATE INDEX area_idx ON floating_options(area_geo) INDEXTYPE IS MDSYS.SPATIAL_INDEX;Error report -SQL Error: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-13203: failed to read USER_SDO_GEOM_METADATA viewORA-13203: failed to read USER_SDO_GEOM_METADATA viewORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I",line 1029855. 00000 - "error occurred in the execution of ODCIINDEXCREATE routine"*Cause: Failed to successfully execute the ODCIIndexCreate routine.*Action: Check to see if the routine has been coded correctly. ' m! u& g: J( M 解决方案:
技术问答
163 人阅读
|
0 人回复
|
2023-09-12
