NIM060000 for ArcSDE/Enterprise Geodatabase

漏洞 ID 编号	NIM060000
已提交	August 13, 2010
上次修改时间	April 2, 2025
适用范围	ArcSDE/Enterprise Geodatabase
找到的版本	10.0
状态	Will Not Be Addressed

附加信息

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.

解决办法

1. Rename the georaster RDT table to the name compatible with ArcSDE.a. After registering the georaster column with ArcSDE, use the sderaster command to obtain the ArcSDE rastercolumn_idsderaster -o add -l gdalt2,shape -k SDO_GEORASTER -i sde:oracle11g -u sde -p sde@orclConnecting to datasource sde:oracle11g, as user sdeArcSDE 10.0 for Oracle11g Build 685 Fri May 14 12:05:43 2010----------------------------------------------------------------Creating raster layer: gdalt2.shapeComplete...sderaster -o describe -l gdalt2,shape -i sde:oracle11g -u sde -p sde@orclConnecting to server markloan, port 9411, as user rasterArcSDE 10.1 for Oracle11g Build 168 Sun Aug 22 12:05:59 2010----------------------------------------------------------------Raster Column ID ............: 1199Table Name ..................: RASTER.GDALT2Raster Column ...............: SHAPEStorage Type ................: GEORASTERConfiguration Keyword .......: SDO_GEORASTERCoordinate System ...........: NonePermission ..................: FullCreated .....................: Mon Aug 23 10:34:43 2010In this case the rdt table we need rename to is SDE_RDT_1199Obtain the current rdt table that was created by querying the georaster column.sqlplus sde/sde@orclSQL> select shape from gdalt2;SHAPE(RASTERTYPE, SPATIALEXTENT(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELE--------------------------------------------------------------------------------SDO_GEORASTER(20001, NULL, 'RDT_1$', 1, XMLTYPE(<georasterMetadata xmlns="<a href="http://xmlns.oracle.com/spatial/georaster" target="_blank">http://xmlns.oracle.com/spatial/georaster</a>"> <objectI))The current RDT table name is RDT_1$.c. To georaster utility to rename the RDT:sqlplus sde/sde@orclSQL> exec sdo_geor_utl.renameRDT ('RDT_1$','SDE_RDT_1199');PL/SQL procedure successfully completed.Now the statistics can be calculated from either sderaster or ArcGIS.