Statistics are not calculated on raster datasets loaded into Raster catalogs by way of GDAL command in Oracle.
最後に公開された状態: August 25, 2014ArcSDE/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.