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
Last revisionBoth sides next revision
contrib:shp2oracle_spatial [2007/07/23 20:45] sleleivacontrib:shp2oracle_spatial [2008/03/14 15:38] – deleted -- obsolete information sleleiva
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: +=== 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 
-    * PORT - port of the DB (must be indicated always) 
-    * SID of the database 
-    * 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/pages/contrib/shp2oracle_spatial.txt · Last modified: 2019/01/16 10:03 by 127.0.0.1