User Tools

Site Tools


contrib:shp2oracle_spatial

Differences

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

Link to this comparison view

Next revision
Previous revision
Next revision Both sides next revision
contrib:shp2oracle_spatial [2007/07/23 20:08]
sleleiva created
contrib:shp2oracle_spatial [2008/03/14 14:06]
sleleiva
Line 1: Line 1:
 For Oracle 10g Release 2 only (10.2g) For Oracle 10g Release 2 only (10.2g)
-Linux:+ 
 +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>
-    * check for you $ORACLE_HOME, if does not exist, create one (depending on your environment):+    * check for you $ORACLE_HOME, if does not exist, create one (depending on your environment):
 <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 14: 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 +    * 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 +    * 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)
 +
 +If anything, contact me (the creator of this page) {at} unibz {dot} it.
/var/www/wiki.inf.unibz.it/data/pages/contrib/shp2oracle_spatial.txt · Last modified: 2019/01/16 10:03 (external edit)