User Tools

Site Tools


contrib:shp2oracle_spatial

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
contrib:shp2oracle_spatial [2008/03/14 13:58]
sleleiva
contrib:shp2oracle_spatial [2008/03/14 14:06]
sleleiva
Line 3: Line 3:
 Linux (MUST BE DONE ON WHERE YOU HAVE ORACLE DB SERVER RUNNING, on BZ10M server, for example): Linux (MUST BE DONE ON WHERE YOU HAVE ORACLE DB SERVER RUNNING, on BZ10M server, for example):
   * Download and unpack http://www.oracle.com/technology/software/products/spatial/files/shape2sdojava.zip   * Download and unpack http://www.oracle.com/technology/software/products/spatial/files/shape2sdojava.zip
 +    * In case the above link no longer works: **''bz10m.inf.unibz.it:/data/spatial/shape/bz10m/buses/networks/util/shape2sdojava.zip''**
   * Compile:   * Compile:
     * cd <into directory where you extracted the archive>     * cd <into directory where you extracted the archive>
Line 16: Line 17:
   * Execute:   * Execute:
 <code bash> <code bash>
-  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+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
 </code> </code>
 where where
     * HOST - Oracle 10.2 hostname (e.g. bz10m.inf.unibz.it)     * HOST - Oracle 10.2 hostname (e.g. bz10m.inf.unibz.it)
-    * PORT - port of the DB (must be indicated always)+    * PORT - port of the DB like 1521 (must be indicated always)
     * SID of the database (e.g. orcl)     * SID of the database (e.g. orcl)
-    * USER - user name +    * USER - username 
-    * PASS - user password+    * PASS - user'password
     * TABLE - spatial table name which will be created in Oracle     * TABLE - spatial table name which will be created in Oracle
     * FILE_NAME - Shapefile name (without extension)     * FILE_NAME - Shapefile name (without extension)
/var/www/wiki.inf.unibz.it/data/pages/contrib/shp2oracle_spatial.txt · Last modified: 2019/01/16 10:03 (external edit)