contrib:shp2oracle_spatial
This is an old revision of the document!
For Oracle 10g Release 2 only (10.2g)
Linux (MUST BE DONE ON WHERE YOU HAVE ORACLE DB SERVER RUNNING, on BZ10M server, for example):
- Compile:
- cd <into directory where you extracted the archive>
- # check for you $ORACLE_HOME, if does not exist, create one (depending on your environment):
set | grep ORACLE_HOME ORACLE_HOME=/usr/app/oracle/oracle/product/10.2.0/db_1 javac -classpath $ORACLE_HOME/jdbc/lib/ojdbc14.jar:./sdoutl.jar:$ORACLE_HOME/md/lib/sdoapi.jar SampleShapefileToJGeomFeature.java
- Execute:
java -cp .:$ORACLE_HOME/jdbc/lib/ojdbc14.jar:sdoutl.jar:$ORACLE_HOME/md/lib/sdoapi.jar SampleShapefileToJGeomFeature -h HOST -p PORT -s SID -u USER -d PASS -t TABLE -f FILE_NAME
where
- HOST - Oracle 10.2 hostname
- PORT - port of the DB (must be indicated always)
- SID of the database
- USER - user name
- PASS - user password
- TABLE - spatial table name which will be created in Oracle
- FILE_NAME - Shapefile name (without extension)
Oracle 10g Release 1 needs additional patches (read about them in shape2sdojava.zip readme.txt.
If anything, contact me (the creator of this page) {at} unibz {dot} it.
/data/www/wiki.inf.unibz.it/data/attic/contrib/shp2oracle_spatial.1197283001.txt.gz · Last modified: 2019/01/16 10:03 (external edit)