Differences

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

--- 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):
   * 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:
     * cd <into directory where you extracted the archive>
@@ Line 16: / Line 17: @@
   * Execute:
 <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>
 where
     * 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)
-    * USER - user name
+    * USER - username
-    * PASS - user password
+    * PASS - user's password
     * TABLE - spatial table name which will be created in Oracle
     * FILE_NAME - Shapefile name (without extension)