Spatial views in ArcSDE allow you to join columns from a 'non-spatial' table in the database to a table with a 'geometry column'. They can also allow you to format and choose the attribute columns that you want to have included in your feature class.
A spatial view is created with the SDE commandline tools to 'register' the view with the geodatabase. The view won't show up in ArcCatalog unless it is registered.
I have a data maintenance process that utilizes spatial views. After running unattended for close to a year, I am now having a problem where the spatial view becomes partially unregistered from the geodatabase. This prevents the geoprocessor from seeing the feature class. It also introduces the fairly common SDE issue where you can't re-create the view because the tool tells you that it already exists, but you can't delete it because the tool tells you that it doesn't exist.
Has anyone else run into this issue and come up with either a prevention or remediation strategy.
Platform: ArcSDE 9.3x, Oracle10g, UNIX.