nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle view as point FC gone!

forestknutsen1

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?

Find more posts tagged with

Accepted answers

Asrujit_SenGupta

If you are using ArcSDE 10.1, then you should be using the SDE Command line tools to register.

sdelayer

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.

https://community.esri.com/groups/geodatabase/blog/2016/12/14/new-at-105-registering-a-database-view-with-the-geodatabase

** My suggestion would be to drop the view and recreate it, to be sure.

All comments

forestknutsen1

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.

Asrujit_SenGupta

If you are using ArcSDE 10.1, then you should be using the SDE Command line tools to register.

sdelayer

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.

https://community.esri.com/groups/geodatabase/blog/2016/12/14/new-at-105-registering-a-database-view-with-the-geodatabase

** My suggestion would be to drop the view and recreate it, to be sure.

forestknutsen1

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.