<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div id="yiv2644825227"><div id="yui_3_16_0_1_1422565774391_2599"><div id="yui_3_16_0_1_1422565774391_2598" style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div dir="ltr" id="yiv2644825227yui_3_16_0_1_1422232623696_1013344">Can't help with plain dblink but we have succeeded with ODBC connections & shell scripts which pipe the result from an Oracle SQL query into a Postgis SQL to transfer the data.</div><div dir="ltr" id="yiv2644825227yui_3_16_0_1_1422232623696_1013330"><br clear="none"></div><div dir="ltr" id="yiv2644825227yui_3_16_0_1_1422232623696_1013343">We have not pursued another approach which we feel is probably viable, which is connecting directly from Oracle to push data, see (amongst several such articles): <br clear="none"></div><div dir="ltr" id="yiv2644825227yui_3_16_0_1_1422232623696_1013372"><a rel="nofollow" shape="rect" id="yiv2644825227yui_3_16_0_1_1422232623696_1013374" target="_blank" href="https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/">https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/</a></div><div id="yui_3_16_0_1_1422565774391_2600" dir="ltr"><br clear="none"></div><div id="yui_3_16_0_1_1422565774391_2601" dir="ltr"><div id="yui_3_16_0_1_1422565774391_2606" dir="ltr">you can also try the Oracle FDW:</div><div id="yui_3_16_0_1_1422565774391_2805" dir="ltr"><a id="yui_3_16_0_1_1422565774391_2806" href="http://laurenz.github.io/oracle_fdw/">http://laurenz.github.io/oracle_fdw/</a><br></div><div id="yui_3_16_0_1_1422565774391_2737" dir="ltr"> <a id="yui_3_16_0_1_1422565774391_2609" href="https://github.com/atris/JDBC_FDW">http://pgxn.org/dist/oracle_fdw/<br></a></div><div id="yui_3_16_0_1_1422565774391_2738" dir="ltr"><br></div><div id="yui_3_16_0_1_1422565774391_2876" dir="ltr"><br></div><div id="yui_3_16_0_1_1422565774391_2877" dir="ltr">HTH,</div><div id="yui_3_16_0_1_1422565774391_2890" dir="ltr"><br></div><div id="yui_3_16_0_1_1422565774391_2891" dir="ltr"> Brent Wood<br></div><div id="yui_3_16_0_1_1422565774391_2640" dir="ltr"><br clear="none"></div><div style="" class="" id="yui_3_16_0_1_1422565774391_2606" dir="ltr"><br></div></div><div id="yiv2644825227yui_3_16_0_1_1422232623696_1013329"><span></span></div><br clear="none"> <div id="yiv2644825227yui_3_16_0_1_1422232623696_1013341" style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div id="yiv2644825227yui_3_16_0_1_1422232623696_1013340" style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div class="qtdSeparateBR"><br><br></div><div class="yiv2644825227yqt1364617211" id="yiv2644825227yqt74466"><div dir="ltr" id="yiv2644825227yui_3_16_0_1_1422232623696_1013342"> <hr id="yiv2644825227yui_3_16_0_1_1422232623696_1013376" size="1"> <font id="yui_3_16_0_1_1422565774391_2892" size="2" face="Arial"> <b id="yui_3_16_0_1_1422565774391_2941"><span id="yui_3_16_0_1_1422565774391_2940" style="font-weight:bold;">From:</span></b> Tahir Tamba <tahir.tamba@gmail.com><br clear="none"> <b><span style="font-weight:bold;">To:</span></b> PostGIS Users Discussion <postgis-users@lists.osgeo.org> <br clear="none"> <b><span style="font-weight:bold;">Sent:</span></b> Friday, January 30, 2015 9:22 AM<br clear="none"> <b id="yui_3_16_0_1_1422565774391_2943"><span id="yui_3_16_0_1_1422565774391_2942" style="font-weight:bold;">Subject:</span></b> [postgis-users] Creating a DBlink to load data from Oracle Spatial to PostGIS<br clear="none"> </font> </div> <div class="yiv2644825227y_msg_container" id="yiv2644825227yui_3_16_0_1_1422232623696_1013339"><br clear="none"><div id="yiv2644825227"><div id="yui_3_16_0_1_1422565774391_2893" dir="ltr">Hi,<br clear="none"><br clear="none">I have a mapping project for generating an atlas from multiple layers from QGIS project. All my layers are stored in PostGIS. For cons, I have many layers to add that are stored in Oracle Spatial database and must be part of the project. This tables are updated in live every day. This is the reason why I don't have any choice to access the data from Oracle database. I already have privileges to access data from Oracle Spatial schema that contains spatial tables.<br clear="none"><br clear="none"> My question is the following . Is it possible to make a DBLink to load the Oracle Spatial database tables in PostGIS database? If yes what is the procedure and steps for loading Oracle Spatialtables into PostgreSQL / PostGIS ?<br clear="none"><br clear="none">Otherwise, are there another ways to load tables from Oracle Spatial database to PostGIS ?<br clear="none"><br clear="none">Any suggestions would be greatly appreciated!<br clear="none"><br clear="none">Regards!<br clear="none"></div></div><br clear="none">_______________________________________________<br clear="none">postgis-users mailing list<br clear="none"><a rel="nofollow" shape="rect" ymailto="mailto:postgis-users@lists.osgeo.org" target="_blank" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br clear="none"><a rel="nofollow" shape="rect" target="_blank" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br clear="none"><br clear="none"></div></div> </div> </div> </div></div></div></div></body></html>