| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| 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-21 09:42:55 |
| Message-ID: | 2ed51ff7fac772ced5a60925de5cb6e4da176f21.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2020-08-20 at 14:30 +0000, 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
> ID NUMBER(38,9),
> P_ID NUMBER(38,9),
> GEOMETRY MDSYS.SDO_GEOMETRY
If the geometries are not exotic, oracle_fdw would do the trick.
You won't be able to install it on a hosted database though.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Förster | 2020-08-21 10:17:14 | Re: > ERROR: syntax error at or near "BYTE" |
| Previous Message | Magnus Hagander | 2020-08-21 08:35:02 | Re: > ERROR: syntax error at or near "BYTE" |