Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Idea: Automate USER_SDO_GEOM_METADATA table

User_1871Apr 2 2023 — edited Apr 4 2023

When we create, modify, or delete an SDO_GEOMETRY column, we need to manually create/modify/delete the associated record in the USER_SDO_GEOM_METADATA table/view. In my opinion, that’s a bit of a nuisance.

Whereas GIS software like ArcGIS Pro automatically manages the associated row in USER_SDO_GEOM_METADATA for you when you create/modify/delete an SDO_GEOMETRY column. That’s pretty handy.

Could Oracle be enhanced so that we don’t need to manually manage USER_SDO_GEOM_METADATA?

Thanks.

This post has been answered by _jum on Apr 5 2023
Jump to Answer
Comments
Post Details
Added on Apr 2 2023
3 comments
228 views