RE: EXTERNAL: Re: Loading Oracle Spatial Data to Postgresql

2020-08-20 Thread Ko, Christina
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:

RE: EXTERNAL: Re: Loading Oracle Spatial Data to Postgresql

2020-08-20 Thread Ko, Christina
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

RE: EXTERNAL: Re: Loading Oracle Spatial Data to Postgresql

2020-08-20 Thread Ko, Christina
-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, >

Loading Oracle Spatial Data to Postgresql

2020-08-20 Thread 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 IDNUMBER(38,9), P_ID NUMBER(38,9), GEOMETRY MDSYS.SDO_GEOMETRY AWS DMS calls the SDO2GEOJSON custom function trying to load the d