|
阅读：2245回复：2
shp2sdo测试
<P>shp2sdo road -g geom -d -x (-180,180) -y (-90,90) -s 4269 -t 0.005 -v</P>
<P>输出日志：</P> <P>shp2sdo - Shapefile(r) To Oracle Spatial Converter<BR>Version 2.15 21-May-2004<BR>Copyright 1997,2004 Oracle Corporation<BR>For use with Oracle Spatial.</P> <P>Processing shapefile road into spatial table ROAD <BR>Data model is object-relational <BR> Geometry column is GEOM <BR> Points stored in SDO_POINT attributes<BR> Data is in the control file(s)<BR> Control file generation for Oracle9i or higher<BR> Spatial data loaded with 6 digits of precision<BR> Bounds set to X=[-180.000000,180.000000] Y=[-90.000000,90.000000]<BR> SRID set to 4269<BR> Tolerance set to 0.005000<BR>Shape File:<BR> Size : 343777868 bytes<BR> Number of shapes : 1864299<BR> Shape type : 3 = Linestring(s)<BR> Bounds : X=[-141.001333,-52.622540] Y=[41.736231,82.514468]<BR> Bounds used: X=[-180.000000,180.000000] Y=[-90.000000,90.000000]<BR>Attribute file:<BR> Number of records : 1864299<BR> Number of attributes : 9<BR> Header length : 321<BR> Record length : 113<BR>Processing Object 100 of 1864299...</P> <P>................................</P> <P>Processing Object 1864299 of 1864299...<BR>Conversion complete : 1864299 linestrings processed<BR>The following files have been created:<BR> road.sql : SQL script to create the table<BR> road.ctl : Control file for loading the table<BR></P> |
|
|
1楼#
发布于：2007-07-13 13:05
<P>sqlplus <a href="mailtgsx/gsx@dev" target="_blank" >gsx/gsx@dev</A> @road.sql</P>
<P>SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 7月 13 12:49:31 2007</P> <P>Copyright (c) 1982, 2005, Oracle. All rights reserved.</P> <P><BR>连接到: <BR>Oracle Database 10g Release 10.2.0.1.0 - Production</P> <P>DROP TABLE ROAD<BR> *<BR>第 1 行出现错误:<BR>ORA-00942: 表或视图不存在</P> <P>表已创建。</P> <P><BR>已删除0行。</P> <P><BR>已创建 1 行。</P> <P><BR>提交完成。</P> <P>SQL> SQL> </P> |
|
|
2楼#
发布于：2007-07-13 13:55
<P>sqlldr <a href="mailtgsx/gsx@dev" target="_blank" >gsx/gsx@dev</A> road.ctl</P>
<P><BR>SQL*Loader: Release 10.2.0.1.0 - Production on 星期五 7月 13 13:30:58 2007</P> <P>Copyright (c) 1982, 2005, Oracle. All rights reserved.</P> <P>达到提交点 - 逻辑记录计数 64<BR>达到提交点 - 逻辑记录计数 128<BR>..................<BR>达到提交点 - 逻辑记录计数 1864298<BR>达到提交点 - 逻辑记录计数 1864299</P> <P><BR>SQL*Loader: Release 10.2.0.1.0 - Production on 星期五 7月 13 13:30:58 2007</P> <P>Copyright (c) 1982, 2005, Oracle. All rights reserved.</P> <P>控制文件: road.ctl<BR>数据文件: road.ctl<BR> 错误文件: road.bad<BR> 废弃文件: 未作指定<BR> <BR>(可废弃所有记录)</P> <P>要加载的数: ALL<BR>要跳过的数: 0<BR>允许的错误: 50<BR>绑定数组: 64 行, 最大 256000 字节<BR>继续: 1: 1 = 0X23(字符 '#'), 在下一个物理记录中<BR>所用路径: 常规</P> <P>表 ROAD,已加载从每个逻辑记录<BR>插入选项对此表 TRUNCATE 生效<BR>TRAILING NULLCOLS 选项生效</P> <P> 列名 位置 长度 中止 包装数据类型<BR>------------------------------ ---------- ----- ---- ---- ---------------------<BR>NGD_ID FIRST * | CHARACTER <BR> NULL if NGD_ID = BLANKS<BR>CLASS NEXT * | CHARACTER <BR> NULL if CLASS = BLANKS<BR>NAME NEXT * | CHARACTER <BR> NULL if NAME = BLANKS<BR>TYPE NEXT * | CHARACTER <BR> NULL if TYPE = BLANKS<BR>DIRECTION NEXT * | CHARACTER <BR> NULL if DIRECTION = BLANKS<BR>ADDR_FM_LE NEXT * | CHARACTER <BR>ADDR_TO_LE NEXT * | CHARACTER <BR>ADDR_FM_RG NEXT * | CHARACTER <BR>ADDR_TO_RG NEXT * | CHARACTER <BR>GEOM DERIVED * COLUMN OBJECT </P> <P>*** GEOM 中的字段<BR>SDO_GTYPE NEXT * | CHARACTER <BR>SDO_SRID NEXT * | CHARACTER <BR>SDO_ELEM_INFO DERIVED * VARRAY <BR> 终止符字符串: '|/'</P> <P>*** GEOM.SDO_ELEM_INFO 中的字段<BR>X FIRST * | CHARACTER <BR>*** GEOM.SDO_ELEM_INFO 中的字段结尾</P> <P>SDO_ORDINATES DERIVED * VARRAY <BR> 终止符字符串: '|/'</P> <P>*** GEOM.SDO_ORDINATES 中的字段<BR>X FIRST * | CHARACTER <BR>*** GEOM.SDO_ORDINATES 中的字段结尾</P> <P>*** GEOM 中的字段结尾</P> <P>表 ROAD:<BR> 1864299 行 加载成功。<BR> 由于数据错误, 0 行 没有加载。<BR> 由于所有 WHEN 子句失败, 0 行 没有加载。<BR> 由于所有字段都为空的, 0 行 没有加载。</P> <P><BR>为绑定数组分配的空间: 215168 字节 (64 行)<BR>读取 缓冲区字节数: 1048576</P> <P>跳过的逻辑记录总数: 0<BR>读取的逻辑记录总数: 1864299<BR>拒绝的逻辑记录总数: 0<BR>废弃的逻辑记录总数: 0</P> <P>从 星期五 7月 13 13:30:58 2007 开始运行<BR>在 星期五 7月 13 13:45:02 2007 处运行结束</P> <P>经过时间为: 00: 12: 53.89<BR>CPU 时间为: 00: 04: 52.06<BR></P> |
|