NIM055449 for ArcSDE/Enterprise Geodatabase

不具合 ID 番号	NIM055449
送信されました	March 17, 2010
最終更新日	April 2, 2025
適用対象	ArcSDE/Enterprise Geodatabase
見つかったバージョン	9.3.1
オペレーティングシステム	Windows OS
オペレーティングシステムのバージョン	2003 64 Bit
修正されたバージョン	N/A
ステータス	Fixed

対処法

1) Put the feature class in load only mode:sdelayer -o load_only_io -l test,shape -i sde_orcl -u user -p passwordArcSDE 9.3 for Oracle10g Build 2784 Tue Oct 27 10:51:14 2009Layer Administration Utility-----------------------------------------------------Layer is now in LOAD-ONLY I/O mode.2) Set grid to automatic. sdelayer -o alter -g automatic -l test,shape -i sde_orcl -u user -p password -NArcSDE 9.3 for Oracle10g Build 2784 Tue Oct 27 10:51:14 2009Layer Administration Utility-----------------------------------------------------Successfully Modified the LayerSuccessfully changed spatial index parametersLayer is in LOAD-ONLY mode3) Put the feature class in Normal IO:sdelayer -o normal_io -l test,shape -i sde_orcl -u user -p passwordArcSDE 9.3 for Oracle10g Build 2784 Tue Oct 27 10:51:14 2009Layer Administration Utility-----------------------------------------------------Layer is now in NORMAL I/O mode.4) Below is an example of a python script that will recalculate and rebuild the spatial indexes. For some reason, when the AddSpatialIndex GP tool is first called, it will only create a spatial index on the base table. If the same toolis called a second time, it will build the index on the Adds table.# ---------------------------------------------------------------------------# <a href="http://CreateSpatialIndex2.py" target="_blank">CreateSpatialIndex2.py</a># Created on: Fri Mar 12 2010 09:50:44 AM# (generated by ArcGIS/ModelBuilder)# ---------------------------------------------------------------------------# Import system modulesimport sys, string, os, arcgisscripting# Create the Geoprocessor objectgp = arcgisscripting.create()# Load required toolboxes...gp.AddToolbox("D:/Program Files (x86)/ArcGIS/ArcToolbox/Toolboxes/Data Management Tools.tbx")# Local variables...TESTFC = "Database Connections<a href="file://sde_orcl.sde//USER.TEST" target="_blank">\\sde_orcl.sde\\USER.TEST</a>"# Process: Calculate Default Spatial Grid Index....indexgrids=gp.CalculateDefaultGridIndex_management(TESTFC)indexgrid1 = indexgrids.split(";")[0] print indexgrid1# Process: Add Spatial Index...# First call rebuilds the spatial index for base table...gp.AddSpatialIndex_management(TESTFC, indexgrid1) # Second call rebuilds the spatial index for Adds table...gp.AddSpatialIndex_management(TESTFC, indexgrid1)5) In Oracle SQL*Plus:SQL> select index_name,index_type from user_indexes where table_name='TEST';INDEX_NAME INDEX_TYPE------------------------------ ---------------------------A52_IX1 DOMAINR130_SDE_ROWID_UK NORMALSYS_IL0000055501C00017$$ LOBSQL> select index_name,index_type from user_indexes where table_name='A130';INDEX_NAME INDEX_TYPE------------------------------ ---------------------------A52_IX1_A DOMAINSYS_IL0000055506C00017$$ LOBA130_STATEID_IX1 NORMALA130_PK NORMAL

再現の手順

不具合 ID: NIM055449

ソフトウェア:

ArcSDE/Enterprise Geodatabase

このトピックについてさらに調べる

ArcGIS エキスパートのサポートを受ける

テクニカルサポートへのお問い合わせ

Esri Support アプリのダウンロード

ダウンロードオプションに移動

The sdelayer -o normal_io does not recreate spatial index on ST_GEOMETRY feature class when base table is empty and all edits are in A and D tables.

対処法

再現の手順

バグのステータスが変更されたときに通知を受け取る

このトピックについてさらに調べる