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. 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): https://dbaspot.wordpress.com/2013/05/29/how-to-access-postgresql-from-oracle-database/ you can also try the Oracle FDW:http://laurenz.github.io/oracle_fdw/ http://pgxn.org/dist/oracle_fdw/
HTH, Brent Wood From: Tahir Tamba <tahir.ta...@gmail.com> To: PostGIS Users Discussion <postgis-users@lists.osgeo.org> Sent: Friday, January 30, 2015 9:22 AM Subject: [postgis-users] Creating a DBlink to load data from Oracle Spatial to PostGIS Hi, 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. 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 ? Otherwise, are there another ways to load tables from Oracle Spatial database to PostGIS ? Any suggestions would be greatly appreciated! Regards! _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
