ArcGIS Pro 3.3.0; Oracle 18c database (non-GDB)
Sometimes database views get broken in ArcGIS Pro. I try to delete the view using Catalog, but I get various errors.
Often, the cause is the view has been deleted from the database. The view was never registered with the geodatabase (in this particular case, the Oracle database is not an enterprise geodatabase, proving that the view isn't registered). So it's unclear why the view persists in Catalog since the view wouldn't be listed in any geodatabase system tables (since the geodatabase system tables don't exist).
How can I delete the broken database view from Catalog?
Solved! Go to Solution.
Create a fake view via a SQL client (outside of Pro) that uses the same name as the broken Catalog view:
create or replace view roll_up_vw as
select
1 as objectid
from
dual
Then, delete the view via Catalog. The view will disappear from Catalog.
Create a fake view via a SQL client (outside of Pro) that uses the same name as the broken Catalog view:
create or replace view roll_up_vw as
select
1 as objectid
from
dual
Then, delete the view via Catalog. The view will disappear from Catalog.