| From: | "Ko, Christina" <christina(dot)ko(at)lmco(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Cc: | "Ho, Chuong" <chuongho(at)amazon(dot)com> |
| Subject: | Loading Oracle Spatial Data to Postgresql |
| Date: | 2020-08-20 14:30:51 |
| Message-ID: | 5786be339b564011987bce94a4f4aba9@lmco.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-08-20 14:42:15 | Re: Loading Oracle Spatial Data to Postgresql |
| Previous Message | Олег Самойлов | 2020-08-20 12:16:10 | Re: BUG? Slave don't reconnect to the master |