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?