I searched for this subject on the internet but could not find a solution to move a complete PostGIS database to Oracle Spatial. All information I found was about Oracle to PostGIS. Could anyone tell me how I can migrate to Oracle?
- Moving the table and field structure (including the projections)
- Moving the data
Many thanks in advance
I would recommend to use an intermediate format like shapefile. First export your tables (Including table structure and data) from the PostGIS using "PostGIS SHapefile Import/Export Manager" which is installed with postgis.
There are some tools to import shapefiles into oracle DB. The one I suggest here is the Georaptor which you can install it as a plugin in Oracle SQL Developer. Georaptor is opensource (free) and easy to use. You can download it from here: