Re: Loading Oracle Spatial Data to Postgresql
| От | Adrian Klaver |
|---|---|
| Тема | Re: Loading Oracle Spatial Data to Postgresql |
| Дата | |
| Msg-id | a4866e62-6a8e-ac88-d6fc-40aa3a6babab@aklaver.com обсуждение исходный текст |
| Ответ на | Loading Oracle Spatial Data to Postgresql ("Ko, Christina" <christina.ko@lmco.com>) |
| Ответы |
RE: EXTERNAL: Re: Loading Oracle Spatial Data to Postgresql
|
| Список | 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.klaver@aklaver.com
В списке pgsql-general по дате отправления: