Spatial (MOSC)

MOSC Banner

Oracle 12c sdo_geometry update failing

edited Aug 27, 2021 7:35PM in Spatial (MOSC) 3 commentsAnswered ✓

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center