There are some invalid views and functions in my database.
I am not sure what changes caused these objects to became invalid since many people are working on the same database.
How can I see which change caused the view to become invalid?
In short, no.
You can however use the
It's quite normal for objects to become invalid in development databases when columns are added to tables etc.
As Phil says, you can't really to this retrospectively.
You can create DDL triggers to capture this in the future however. These will fire before/after a DDL event, allowing you to capture the dependencies to a table:
Note that just because an object is listed as a dependency, doesn't necessarily mean it'll be invalidated when you modify the base object. This becomes more likely in 11g with its finer-grained dependencies. So you'll need to extend this to check the
A word of warning - if you manage to (permanently) invalidate the