Re: Loading Oracle Spatial Data to Postgresql

2020-08-21 Thread Laurenz Albe
On Thu, 2020-08-20 at 14:30 +, Ko, Christina wrote: > 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 If th

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 Gilles Darold
Le 20/08/2020 à 17:57, Ko, Christina a écrit : *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

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

2020-08-20 Thread Adrian Klaver
On 8/20/20 7:57 AM, Ko, Christina wrote: -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

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 Ron
On 8/20/20 9:57 AM, Ko, Christina wrote: -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

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, >

Re: Loading Oracle Spatial Data to Postgresql

2020-08-20 Thread Gilles Darold
Le 20/08/2020 à 16:30, Ko, Christina a écrit : 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

Re: Loading Oracle Spatial Data to Postgresql

2020-08-20 Thread Adrian Klaver
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 fun