Loading Oracle Spatial Data to Postgresql

["Ko, Christina" <christina.ko@xxxxxxxx>]

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