Get notification about invalid views
0
votes
1
answer
112
views
I have 40 views that are integrated/synced to a work order management system on a weekly basis.
The views are based on GIS tables which are *notoriously messy*. Over time, the views can end up becoming **invalid**.
Example:
- A user deletes or renames a column in an underlying table, but fails to notify I.T. of the change, so the view is not updated accordingly.
- As a result, the view would become invalid:
ORA-04063: view "ROADS_VW" has errors
or ORA-00904: "FIELD1": invalid identifier
.
--------
I would like to catch & fix invalid views (or fix the underlying data) before the views are synced to the work order management system each week.
**Is there a way to get Oracle to notify me about invalid views?**
For instance, if the integrations occur on Fridays, then get an email on Thursdays if any of the views are invalid.
Asked by User1974
(1527 rep)
Oct 13, 2019, 06:05 PM
Last activity: Oct 14, 2019, 08:27 AM
Last activity: Oct 14, 2019, 08:27 AM