Quick Reference – How to import ESRI Shapefiles into Oracle Spatial
Launch Oracle Map Builder and connect to the database
(% java –jar mapbuilder.jar [Options])
On the Tools Menu, Select Import Shapefile
The Importing Shapefile wizard will launch. Click the Next Button
Locate the .shp file to load and click the Open Button
The Data Selection section will populate with some default options. Update as desired and click the Next button
Select the associated Spatial Reference System for the shapefile and click the Ok button
Confirm the Spatial Reference Information and select the desired Table Information options. Click the Next button.
Create a predefined theme using an existing style if desired and click the Next button
Confirm the data in the Summary report. If correct click the Finish button to run the import. A status window will display during the import
Once loaded, expand the Show Data window and see the available Spatial Tables in the database. Expand the Geometry Tables folder and locate the newly created table. Right Click on the name of the table and select “Create/Update Spatial Index”
Click the Build button to re-build the spatial index