Occasionally, schema changes that are made in my tables cause errors in my views. Example: a field is changed in a table that was referenced by a view.
When there are errors in a view, ArcGIS Desktop throws errors:
- When the view is dragged to ArcMap, error: 'Could not add the specified data object to the map. DBMS table not found [ORA-24372: invalid object for describe]'
- When double clicked in Catalog, error: 'Failed to edit the selected object(s).'
- When right clicked >> Properties in Catalog: Nothing happens
I would like to either modify/fix the view's definition(SQL) or, at the very least, get the SQL, and then delete the broken VIEW and recreate it with working SQL. However, because there are errors, ArcGIS is not letting me get to the view's properties or the view's definition tab, to get at the SQL.
How can I fix the definition(SQL) of a view that has errors in ArcGIS Desktop?
- ArcGIS Desktop 10.3.1
- SDE 10.3.1
- Oracle 12c (22.214.171.124.0)
I do not have access to SQL Plus. I only have ArcGIS Desktop and MS Access, and do not have DBA privileges.