[postgis-users] importing tables from Oracle

[dustymugs]

Assuming you have a recent version of PostgreSQL, you might be able to
try the foreign data wrapper for Oracle.

http://wiki.postgresql.org/wiki/Foreign_data_wrappers#oracle_fdw

-bborie

On 06/24/2013 02:07 PM, John Callahan wrote:
> I know this is more of a Postgres question than PostGIS...
> 
> I want to import some tables from our primary Oracle database into a
> Postgres 9 database on a regular basis, probably weekly.  Once in Postgres,
> I have some scripts that create spatial objects, create indexes, and the
> tables are then using in GeoServer and desktop GIS.
> 
> Are there any preferred methods to get tables from Oracle to Postgres?
>  dblink seems to be only for other Postgres databases.  The Perl package
> Ora2pg seems like an option but haven't heard of it before today.  A simply
> brute force method could to be write a simple program to extract the oracle
> tables into CSV files and then run postgres COPY to ingest the files.  Not
> very elegant but should work.  Thanks.
> 
> - John
> 
> 
> John Callahan
> Research Scientist
> Delaware Geological Survey
> University of Delaware
> http://www.dgs.udel.edu
> john.callahan at udel.edu
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>