Here is the complete workflow:
- use ArcCatalog (Standard, 10.1, SP1)
- navigate to SDE Oracle 10.0 SP5 geodatabase- right click | New | View
- enter in view name (i.e., SL_TEST_SV)
- enter in view criteria such as 'select * from FS_TreeInventory' or 'select oid, shape, treeid from FS_TreeInventory'
(this is a point feature class, registered with the geodatabase, not versioned, stored using ST_Geometry)
- we have also tried with line and polygon feature classes in the same and other geodatabaseswith the same configuration mentioned above
- the view creates without error and appears in the geodatabase listing
- attempts to preview the view return the following error message 'Operation Failed, Error Opening Feature Class'
If the same process is repeated on a table, and not a feature class, or the query does not involve the shape column, the view is created and can be previewed.
If we right click on the resulting spatial view, the option to register with the geodatabase is greyed out/unavailable. Another source of confusion as either this implies that this spatial view cannot be registered with the geodatabase, or it already is.