This content has been marked as final. Show 33 replies
These files are compressed so you will need to uncompress them. This will give the fileset which is produced for the ESRI GIS suite of programs.
Tke a look at http://www.oracle.com/technology/products/spatial/pdf/spatial_best_practices.pdf.
Also look at https://wiki.deegree.org/deegreeWiki/OracleShapeImport.
I have uncompress all these files.
Now, I have 4 files for every shapefile:
Now I have about....3 millions of this files!
I tried to use shp2sdo, and the most important problem is:
Must I do ONE script with shp2sdo for every single file??? (about 3 millions of scripts!!!!)
I think that this is impossible because I will finish it in a year...
Or, what I wrong?
thank you for your help
Edited by: user8959984 on 18-feb-2010 1.36
I suggest you to use MapBuilder. It can "batch-import" your shapefiles (so you don't have to do it one-by-one using shp2sdo), and it creates the metadata, and spatial index too.
Here you can find MapBuilder: http://www.oracle.com/technology/software/products/mapviewer/index.html
Extract the files, and start mapbuilder.jar (it has a GUI). Connect to your database, and after that, under the Tools menu, select the Import shapefile item. There you'll find the batch import option.
Edited by: Salaj on 2010.02.18. 4:51
thank you for your suggest.
now I'm trying your solution.
I launch in this moment Map Builder and I'm trying to connect Database.
But before of this, I have a question (I'm beginner...):
Is required to have installed the Oracle Fusion Middleware for use MapBuider?
Because I haven't installed Oracle Fusion Middleware.
If it's required, where I can download it?
You can use MapBuilder to use view the shapefiles you loaded into the database.
When you load these shapefiles, it will ask you if you want to create a theme for it.
If you answered yes, you will have these themes already created for you and you can view them under Themes.
If not, you can create new themes from the tables and view the data.