topic Re: How to delete a nonexistent, broken database view from Catalog in ArcGIS Pro Questions

Delete a nonexistent, broken database view from Catalog

Bud — Fri, 10 May 2024 13:58:37 GMT

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?

Re: How to delete a nonexistent, broken database view from Catalog

Bud — Fri, 10 May 2024 13:57:16 GMT

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.

Re: How to delete a nonexistent, broken database view from Catalog

AliciaMcMurchie1 — Thu, 26 Sep 2024 23:48:59 GMT

Will this solution work for a broken database view in an Enterprise Geodatabase, too?

Re: How to delete a nonexistent, broken database view from Catalog

Bud — Fri, 27 Sep 2024 11:34:25 GMT

Yes. I think @MarceloMarques would agree.

Re: How to delete a nonexistent, broken database view from Catalog

AliciaMcMurchie1 — Fri, 27 Sep 2024 16:52:47 GMT

Thanks! I had broken a database view in an Enterprise GDB by changing a field name instead of alias in the feature class it referenced, causing me to be unable to delete the DB view. Changing the field name back in the feature class "fixed" the DB view and I was able to removed it, though. It's good to know there's another solution in case something else caused a DB view to break, though.