laptop and a wrench

Erro

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

Última Publicação: August 25, 2014 ArcSDE/Enterprise Geodatabase
Número de ID do Erro NIM060000
EnviadoAugust 13, 2010
Última ModificaçãoApril 2, 2025
Aplica-se àArcSDE/Enterprise Geodatabase
Versão encontrada10.0
StatusWill Not Be Addressed

Informações Adicionais

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.

Solução Provisória

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.

Etapas para Reproduzir

ID do Erro: NIM060000

Software:

  • ArcSDE/Enterprise Geodatabase

Seja notificado quando o status de um erro mudar

Baixe o Aplicativo de Suporte da Esri

Descubra mais sobre este tema

Obtenha ajuda de especialistas do ArcGIS

Entre em contato com Suporte Técnico

Baixe o Aplicativo de Suporte da Esri

Ir para as opções de download