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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Importing Rectified or SDO_MIGRATED geometry returning error ORA-13367

User_VGV7DSep 27 2022

Hi,
I have upgraded oracle 12c to oracle 19c. I have received error ORA-13367.
Based on the documentations, I have fixed the geometry column by using "SDO_MIGRATE.TO_CURRENT('boundary')" and "sdo_util.rectify_geometry(boundary, 0.05)" functions fix ORA-13367 error. I have exported the shapefile by using Qgis.
My issue is when I Import rectified geometry back to table. Im still receiving ORA-13367 error.
Does anyone know how I can use fixed shapefile?
Are these functions doings something else than just fixing geometry?

Thank you in Advance

Added on Sep 27 2022

#19-3-3, #database-key-features, #oracle, #spatial

2 comments

577 views