Invalid objects - how to know the reason?

[RodrigoValentim]

Good people, the doubt is the following ...

I wanted to know the reason / date / hour that made an object invalid, is there that possibility?

[victorhugomuniz]

In my old project we have problems as follows:


existed procedures that made inserts or delets in some table that contained triggers, and during the execution of this CAPS well prior to an operation of insert to trigger was disabled because the insert did not need the interference of the trigger and then after the commit the trigger was again enabled ..
we took a lot to find that if there was an error during insert the trigger had already been disabled and would not be enabled again because the execution of procede would be interrupted ..

had another situation that several procs depended on other procs .. if any changed, we should compile all in the order

I just tried to help ... I saw that you want something to investigate or a log with these information

[RodrigoValentim]

Yes, I have already investigated this but the procedures were invalid, that is, the people were changed and the objects were not compiled ... The problem is that this happened around 01:30 from the Madruga !! (I have an emails routine that alerts invalid objects)

[diegolenhardt]

See if you help you face

Select all

select text from dba_errors 
where owner = 'XX' 
AND NAME = 'OBJETO' 
 
SELECT LAST_DDL_TIME 
FROM DBA_OBJECTS

[RodrigoValentim]

Thanks, I was referring to this table after the corrected error and has to be at the same time. solved!