Loading Oracle Spatial Data to Postgresql

[Ko, Christina]

Hi All,

I am running into issue using DMS to load oracle spatial data (oracle 11.2.0.3) 
to postgresql.

Oracle table:

CREATE TABLE Spatial_Tbl
 ID        NUMBER(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

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.



Thanks in advanced for your help!



Christina