Bogue
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.
| Numéro d’ID de bogue | NIM055449 |
|---|---|
| Envoi | March 17, 2010 |
| Dernière modification | April 2, 2025 |
| S’applique à | ArcSDE/Enterprise Geodatabase |
| Version trouvée | 9.3.1 |
| Système d’exploitation | Windows OS |
| Version du système d’exploitation | 2003 64 Bit |
| Version de correction | N/A |
| Statut | Fixed |
Solution de contournement
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Étapes pour reproduire
ID de bogue: NIM055449
Logiciel:
- ArcSDE/Enterprise Geodatabase
Recevoir une notification lorsque le statut d’un bogue change
En savoir plus sur ce sujet
Rechercher des informations associées
Rechercher une formation sur ce sujet
Explorer des pistes et donner un avis
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support