How to move spatial data from Oracle to Postgres

Question

Does anyone have a clear document on how to move Orace Spatial data to Postgres (both Community version and Enterprise DB... Thanks

Answer 1

First, on Postgres you will need to install PostGIS. Then export your Oracle tables either to Shapefile (try SD02SHP described here) or to KML. If you can export them to shapefile, reimport them to PostGIS with shp2pgsql per these instructions. If you use kml, reimport the geometry with the geometry constructor ST_GeomFromKML.

Answer 2

You could also probably export the geometries from Oracle as Well Known Text and then reimport them. This would require you writing import statements for the tables which should be pretty easy to create