0:下载shp2sdo.exe,拷贝到oracle安装目录的D:/oracle/product/10.2.0/db_1/bin文件夹下。
1:shp文件路径:D:\project\GC\shp\point.shp
2:D:\project\GC\shp>shp2sdo point gcpoint -g geom -d -s 4326 -t 0.5 -v
3:生成两个文件gcpoint.sql,gcpoint.ctl
4:连接数据库 sqlplus prjzyml/prjzyml@db11g.geoway.net:1521/dB11G
5:SQL>@D:\project\GC\shp\gcpoint.sql
6:SQL> quit
7:sqlldr prjzyml/prjzyml@db11g.geoway.net:1521/dB11G
8:control = D:\project\GC\shp\gcpoint.ctl
9:建立空间索引 createindexIDX_GCPOINTonGCPOINT(geom) indextypeismdsys.spatial_index;
10:Oracle数据处理(对Oracle地理空间数据进行升级)
sqlplus prjzyml/prjzyml@db11g.geoway.net:1521/dB11G
SQL> EXECUTE SDO_MIGRATE.TO_CURRENT('GCPOINT','GEOM');
没有这一步,geoserver发布图层后,Tomcat后台可能会报ERROR: [geoserver.ows] Rendering process failedCaused by:java.lang.ArithmeticException: /by zero,而图层也不难正常显示,会报Rendering process failed /by zero错误