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
