[postgis-users] Creating a DBlink to load data from Oracle Spatial to PostGIS

[Tahir Tamba]

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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150129/66a15a6c/attachment.html>