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; } } }

Delete a nonexistent, broken database view from Catalog

BB1234

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?

Encuentra más publicaciones etiquetadas con

Accepted answers

BB1234

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.

All comments

alicia.mcmurchie_commtrans

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.

BB1234

Yes. I think @MarceloMarques would agree.

alicia.mcmurchie_commtrans

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

BB1234

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.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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