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 > [email protected] > > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
