Re: Loading Oracle Spatial Data to Postgresql

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@aklaver.com