On 8/20/20 7:30 AM, Ko, Christina wrote:
Hi All,
I am running into issue using DMS to load oracle spatial data (oracle
11.2.0.3) to postgresql.
Oracle table:
CREATETABLESpatial_Tbl
IDNUMBER(38,9),
P_ID NUMBER(38,9),
GEOMETRY MDSYS.SDO_GEOMETRY
AWS DMS calls the SDO2GEOJSON custom function trying to load the data,
but it failed and the Geometry columns in Postgresql was empty
The query?
The error messages?
Postgres version?
Postgres table schema?
I also tried using SDO_UTIL.TO_GEOJSON utility and didn’t work either.
I am looking for suggestions of how to load the geometry data from
oracle 11.2.0.3 to oracle.
I'm assuming you mean oracle 11.2.0.3 to Postgres?
Thanks in advanced for your help!
Christina
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
