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