When this occurs, check for the following:
· Does the table have a spatial index? Spatial queries require a spatial index, and spatial queries are needed for panning and zooming.
· Is the spatial index an R-tree index? The R-tree spatial index should only be used for the first two dimensions(X and Y).Three or four dimensional R-tree indexes do not consistently return all candidate features.
· Does the table contain unsupported geometry types? If so, they will not be drawn by ArcGIS.
· Has the table been correctly registered with a valid row_id column?
· The Oracle Spatial index relies on correct information in the USER_SDO_GEOM_METADATA view to produce a valid Oracle Spatial index for the data. If for any reason the dimension (X, Y, Z or M) information in this view is incorrect, the index may be invalid.
For further details on the Oracle Spatial index please see the Oracle Spatial User Guide and Reference for the appropriate release.