[postgis-users] importing tables from Oracle

[John Callahan]

This looks ideal.  I'll need to upgrade my software to support this but it
should do exactly what I need.   I'm still using Postgres 9.0/PostGIS 2.0
and will likely upgrade to PG 9.3/PostGIS 2.1 when they get released.
 Thanks.


- John


John Callahan
Research Scientist
Delaware Geological Survey
University of Delaware
http://www.dgs.udel.edu
john.callahan at udel.edu



On Mon, Jun 24, 2013 at 5:09 PM, dustymugs <dustymugs at gmail.com> wrote:

> 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
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130624/10454882/attachment.html>