Re: Script to detect any changes to database
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 27 Jan 2009 13:38:44 +0000 (UTC)
Message-ID: <gln2p4$b4p$3_at_solani.org>
On Tue, 27 Jan 2009 03:57:58 -0800, trub3101 wrote:
Date: Tue, 27 Jan 2009 13:38:44 +0000 (UTC)
Message-ID: <gln2p4$b4p$3_at_solani.org>
On Tue, 27 Jan 2009 03:57:58 -0800, trub3101 wrote:
> Hi,
>
> Would anyone have a nice neat little script that can do the above? Also
> what the actual changes were would be handy!
>
> Many thanks,
>
> tb3101
It's called "auditing" and it's free in the recent versions of the database. It was introduced in Oracle 5 (I am sure that Oracle 5.1.22 had auditing) and is an integral part of the Oracle RDBMS ever since.
-- Mladen Gogala http://mgogala.freehostia.comReceived on Tue Jan 27 2009 - 07:38:44 CST