Loading Oracle Spatial Data to Postgresql - Mailing list pgsql-general

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