Skip to Main Content

Database Software

Announcement

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

How to convert CLOB WTK Polygons to sdo_geometry?

Cincocielos_NZDec 5 2022

Hello everyone, I need to migrate information from Postgres(postgis) to Oracle.
I extract information from postgres using st_astext(geom) and upload that information to oracle.
In oracle I have this WKT information
MULTIPOLYGON(((1685401.75223327 6101109.67645498,1685421.07276106 6101104.79940589,1685401.75223327 6101109.67645498)))
And now I need to convert to sdo_geometry, I tried:
select sdo_geometry(geom ,2193) from upload_geom; -- (I got null in columns)
and tried this
SDO_UTIL.FROM_WKTGEOMETRY(geom) -- Geting null
After the conversion I tried also to display the information in Oracle Spatial Studio but I got a message "WITHOUT GEOMETRIES"

What should be the correct way to migrate geospatial information from postgres to oracle, or what is missing?

Cheers.
MG

This post has been answered by Rick Anderson-Oracle on Dec 6 2022
Jump to Answer
Comments
Post Details
Added on Dec 5 2022
5 comments
386 views