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