Bug: Data does not draw when zooming into a spatial view created on an SDEBINARY or SDELOB feature class
After upgrading to ArcSDE 9.2 Service Pack 5 for Oracle, when zooming into a spatial view created on an SDEBINARY or SDELOB feature class, the data does not draw.
This issue only occurs with ArcSDE 9.2 Service Pack 5 for Oracle 9i and 10g when features are stored as type SDEBINARY or SDELOB and when spatial views are part of the workflow. Geodatabase feature classes with geometry stored in Oracle 9i and 10g as type SDO_GEOMETRY or ST_GEOMETRY are not affected.
Spatial views are created with the sdetable -o create_view command with the spatial column of the subject feature class included in the view definition. With ArcSDE 9.2 Service Pack 5, in conjunction with ArcGIS 9.2 and ArcIMS 9.2, features in the spatial view do not display when zooming. The features are still in the feature class; however, they do not display.
Some users may be able to employ a temporary workaround using definition queries. If a definition query is set so that it is true for all features (e.g. 1=1), the features should draw.
For additional information, contact ESRI Support.