contrib:shp2oracle_spatial
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
contrib:shp2oracle_spatial [2007/07/23 20:45] – sleleiva | 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:// | * Download and unpack http:// | ||
+ | * In case the above link no longer works: **'' | ||
* Compile: | * Compile: | ||
* cd <into directory where you extracted the archive> | * cd <into directory where you extracted the archive> | ||
- | * # check for you $ORACLE_HOME, | + | * check for you $ORACLE_HOME, |
< | < | ||
set | grep ORACLE_HOME | set | grep ORACLE_HOME | ||
- | ORACLE_HOME=/ | + | </ |
+ | should output something like **ORACLE_HOME=/ | ||
+ | < | ||
javac -classpath $ORACLE_HOME/ | javac -classpath $ORACLE_HOME/ | ||
</ | </ | ||
Line 15: | Line 17: | ||
* Execute: | * Execute: | ||
<code bash> | <code bash> | ||
- | | + | java -cp .: |
</ | </ | ||
where | where | ||
- | * HOST - Oracle 10.2 hostname | + | * HOST - Oracle 10.2 hostname |
- | * 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 |
- | * USER - user name | + | * USER - username |
- | * PASS - user password | + | * PASS - user' |
* 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