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
contrib:shp2oracle_spatial [2007/12/10 11:56] tchoesangcontrib:shp2oracle_spatial [2019/01/16 10:03] (current) – external edit 127.0.0.1
Line 1: Line 1:
-For Oracle 10g Release 2 only (10.2g)+=== This page has been moved to: === 
 +https://www.inf.unibz.it/dis/wiki/doku.php?id=projects:bz10m:data:shp2oracle_spatial
  
-Linux (MUST BE DONE ON WHERE YOU HAVE ORACLE DB SERVER RUNNING, on BZ10M server, for example): +=== Please update your records===
-  * Download and unpack http://www.oracle.com/technology/software/products/spatial/files/shape2sdojava.zip +
-  * Compile: +
-    * cd <into directory where you extracted the archive> +
-    * # check for you $ORACLE_HOME, if does not exist, create one (depending on your environment): +
-<code> +
-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 
-</code> 
  
-  * 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 
-</code> 
-where 
-    * HOST - Oracle 10.2 hostname (e.g. bz10m.inf.unibz.it) 
-    * PORT - port of the DB (must be indicated always) 
-    * SID of the database (e.g. orcl) 
-    * 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.1197284190.txt.gz · Last modified: 2019/01/16 10:03 (external edit)