Creating a DBlink to load data from Oracle Spatial to PostGIS
2015-01-29 20:22:15 GMT
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!
_______________________________________________ postgis-users mailing list postgis-users <at> lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users