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