From: Gilles Darold
Sent: Thursday, August 20, 2020 1:59 PM
To: Ko, Christina (US) ;
pgsql-general@lists.postgresql.org
Cc: Ho, Chuong
Subject: Re: EXTERNAL: Re: Loading Oracle Spatial Data to Postgresql
Le 20/08/2020 à 17:57, Ko, Christina a écrit :
From: Gilles Darold <mailto:
From: Gilles Darold
Sent: Thursday, August 20, 2020 10:54 AM
To: Ko, Christina (US) ;
pgsql-general@lists.postgresql.org
Cc: Ho, Chuong
Subject: EXTERNAL: Re: Loading Oracle Spatial Data to Postgresql
Le 20/08/2020 à 16:30, Ko, Christina a écrit :
Hi All,
I am running into issue using DMS
-Original Message-
From: Adrian Klaver
Sent: Thursday, August 20, 2020 10:42 AM
To: Ko, Christina (US) ;
pgsql-general@lists.postgresql.org
Cc: Ho, Chuong
Subject: EXTERNAL: Re: Loading Oracle Spatial Data to Postgresql
On 8/20/20 7:30 AM, Ko, Christina wrote:
> Hi All,
>
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
IDNUMBER(38,9),
P_ID NUMBER(38,9),
GEOMETRY MDSYS.SDO_GEOMETRY
AWS DMS calls the SDO2GEOJSON custom function trying to load the d