Home » Server Options » Spatial » Problem when Loading ESRI Shapefiles into Spatial (Oracle 10g , CentOS)
Problem when Loading ESRI Shapefiles into Spatial [message #516544] Tue, 19 July 2011 03:41
ntt85
Messages: 34
Registered: July 2011
Location: vietnam
Member

Hi all,

I have shapefiles need to load data to Oracle Spatial.
Because of I am using Oracle 10g, I set clpath is : /opt/oracle/102/jdbc/lib/ojdbc14.jar:/opt/oracle/102/md/lib/sdoutl.jar:/opt/oracle/102/md/lib/sdoapi.jar.
Then:
java -cp $clpath oracle.spatial.util.SampleShapefileToJGeomFeature -h [server-name] -p [port] -s [sid] -u [user] -d [pass] -t ranhgioi_polyline -f /opt/oracle/shape/ranhgioi_polyline -r 8307 -g geom


The screen display:
Parameters:
<Filename>: File name of an input Shapefile (without extension)
<Table name>: Table name for the result
[SRID]: Valid Oracle SRID for coordinate system; use 0 if unknown
<ID Column name>: Column name for unique numeric ID; if required

Could you help me load that shapefile to oracle.Many thanks.

[Updated on: Tue, 19 July 2011 03:43]

Report message to a moderator

Previous Topic: error while updating SRID to null
Next Topic: How to determine a point is inside a polygon area?
Goto Forum:
  


Current Time: Thu Mar 28 06:38:48 CDT 2024