laptop and a wrench

Error

Statistics are not calculated on raster datasets loaded into Raster catalogs by way of GDAL command in Oracle.

Última publicación: August 25, 2014 ArcSDE/Enterprise Geodatabase
Número de ID del error NIM060000
EnviadoAugust 13, 2010
Última modificaciónApril 2, 2025
Relacionado conArcSDE/Enterprise Geodatabase
Versión encontrada10.0
EstadoWill Not Be Addressed

Información adicional

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.

Solución alternativa

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.

Pasos para reproducir

ID del error: NIM060000

Software:

  • ArcSDE/Enterprise Geodatabase

Recibir notificaciones cuando cambie el estado de un error

Descargar la aplicación de soporte de Esri

Descubrir más sobre este tema

Obtener ayuda de expertos en ArcGIS

Contactar con el soporte técnico

Descargar la aplicación de soporte de Esri

Ir a opciones de descarga