| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | "Ko, Christina" <christina(dot)ko(at)lmco(dot)com>, "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: | Re: Loading Oracle Spatial Data to Postgresql |
| Date: | 2020-08-20 14:42:15 |
| Message-ID: | a4866e62-6a8e-ac88-d6fc-40aa3a6babab@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gilles Darold | 2020-08-20 14:54:18 | Re: Loading Oracle Spatial Data to Postgresql |
| Previous Message | Ko, Christina | 2020-08-20 14:30:51 | Loading Oracle Spatial Data to Postgresql |