Is This Content Helpful?
We're glad to know this article was helpful.
Unable to zoom, pan, or perform spatial queries on Oracle 8i Spatial feature classes with measures or Z values, such as those having more than two dimensions, loaded with ArcGIS.
When ArcGIS loads a shapefile into a feature class on an ArcSDE for Oracle 8i server, it creates an R-tree Oracle Spatial index. The number of indexes dimensioned defaults to the number of dimensions in the shapefile, including Z and M.
R-tree spatial indexes do not work well when more than the X and Y dimensions are spatially indexed.
Include the following DBTUNE parameter in the configuration keyword that loads the shapefile into the feature class.
SDO_INDEX_SHAPE can also contain other parameters used to create the spatial index. These parameters can be combined in the quoted list of parameter=value pairs. Please see the "ArcSDE Configuration and Tuning Guide for Oracle" for more information on using DBTUNE parameters to control feature class creation.