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 revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
contrib:shp2oracle_spatial [2008/03/14 13:48] sleleivacontrib: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 8: Line 9:
 <code> <code>
 set | grep ORACLE_HOME set | grep ORACLE_HOME
-ORACLE_HOME=/usr/app/oracle/oracle/product/10.2.0/db_1 +</code> 
 +should output something like **ORACLE_HOME=/usr/app/oracle/oracle/product/10.2.0/db_1** 
 +<code>
 javac -classpath $ORACLE_HOME/jdbc/lib/ojdbc14.jar:./sdoutl.jar:$ORACLE_HOME/md/lib/sdoapi.jar SampleShapefileToJGeomFeature.java javac -classpath $ORACLE_HOME/jdbc/lib/ojdbc14.jar:./sdoutl.jar:$ORACLE_HOME/md/lib/sdoapi.jar SampleShapefileToJGeomFeature.java
 </code> </code>
Line 15: 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)
  
  
-Oracle 10g Release 1 needs additional patches (read about them in shape2sdojava.zip readme.txt.+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. If anything, contact me (the creator of this page) {at} unibz {dot} it.
/data/www/wiki.inf.unibz.it/data/pages/contrib/shp2oracle_spatial.txt · Last modified: 2019/01/16 10:03 by 127.0.0.1