Try auditing DDL statements? Check out the "audit_ddl.sql" script at
http://www.EvDBT.com/tools.htm for enabling this....
John Kanagaraj wrote:
> Paula,
>
>> 2-What is the most efficient way to track WHAT made a package go
>> invalid?
>
> You might want to place a DDL trigger in the database to keep track of
> what changes are ongoing.... this might give you additional clues.....
> Let me know if you want the code for this (I remember I posted this to
> the list a while ago)
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 02 2007 - 19:23:38 CDT
