Re: auditing package alterations

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 16 Mar 2004 18:37:45 +0100
Message-ID: <8nee50l30ao1iedfckpthkqp7h230thi34@4ax.com>

On Tue, 16 Mar 2004 16:19:05 +0100, Marcin <marrgo72Rem0ve_at_gazeta.pl> wrote:

>Hello!
>
>I've got a question to specialists :-)
>
>How to audit all package/procedure/function alterations, such as package
>recompilations?
>
>What would be the audit statement for this?
>
>Thanks in advance,
>Marcin

The one you look up in the documentation. Apart from that the LAST_DDL_TIME is in dba|all|user|_objects. Please do not misuse these forums as a first resort, when you could find the answer (with a little thinking of your own) in less than 5 minutes.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Mar 16 2004 - 11:37:45 CST