All geek questions in one place

Determining when an Oracle database object has become invalid

Is it possible to determine when an object in an Oracle database has become invalid?

I tried to take a look at the view DBA_OBJECTS, but none of its date stamp columns affects when it STATUSchanges to 'INVALID'.

+3
source share
3 answers

Something must happen to invalidate the object. This is usually a modification of the reference object. Turn on database auditing in DDL, and you should catch changes to objects that cause other objects to become invalid.

+1
source

. , , ( DBA_DEPENDENCIES) - - , . , , , , .

+2

OEM reports
If you have an OEM setup, you can view reports on daily items. This is a manual decision, it does not matter if the data in these reports is accessible or LOB data.

0
source

Source: https://habr.com/ru/post/1718400/

More articles:


All Articles