NIM060000 for ArcSDE/Enterprise Geodatabase

Bug-ID-Nummer	NIM060000
Eingereicht	August 13, 2010
Zuletzt geändert	April 2, 2025
Gilt für	ArcSDE/Enterprise Geodatabase
Gefunden in Version	10.0
Status	Will Not Be Addressed

Zusätzliche Informationen

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.

Workaround

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.