Oracle 12c sdo_geometry update failing
When updating a spatial column in Table A (data type = sdo_geometry) from spatial column in Table B (data type = sdo_geometry) the spatial data is lost or incorrect after the update.
The following command was used:
UPDATE table1 t1 SET (shape) = (SELECT t2.geometry FROM table2 t2 WHERE t1.id = t2.id)
Using an database connection in ESRI ArcGIS Pro to view the table geometry. Table A looks great before and after. Table B does not display the geometry correctly after update
Ideas on why geometry is being lost?