I have an oracle view that was setup to look like a point FC in ArcCatalog at some point. And now it is missing in the prod environment and in turn breaking stuff. However, at a database (ddl level) level they look the same. So, I am wondering...
1) How is this done in the first place?
2) What could have changed in prod to make it vanish?
3) How can I restore it and save the day?