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?
Solved! Go to Solution.
If you are using ArcSDE 10.1, then you should be using the SDE Command line tools to register.
The functionality of registering Views with the geodatabase, using the "Register with Geodatabase" tool was introduced with ArcGIS 10.5.x, so you won't see that in the previous versions.
** My suggestion would be to drop the view and recreate it, to be sure.
Looks like this is how to do it in the first place... Register a table or view with the geodatabase—ArcGIS Help | ArcGIS Desktop
But it is not showing up. Arc 10.1
If you are using ArcSDE 10.1, then you should be using the SDE Command line tools to register.
The functionality of registering Views with the geodatabase, using the "Register with Geodatabase" tool was introduced with ArcGIS 10.5.x, so you won't see that in the previous versions.
** My suggestion would be to drop the view and recreate it, to be sure.
I was able to recreate the view with arcsde command line tools and register it. Still no clue on how it got twisted to start with... Thanks for the help Asrujit.