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
Last revisionBoth sides next revision
contrib:shp2oracle_spatial [2007/07/23 20:08] – created 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=== 
-Linux+https://www.inf.unibz.it/dis/wiki/doku.php?id=projects:bz10m:data:shp2oracle_spatial
-  * 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 +=== Please update your records===
-</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) 
  
/data/www/wiki.inf.unibz.it/data/pages/contrib/shp2oracle_spatial.txt · Last modified: 2019/01/16 10:03 by 127.0.0.1