Re: Script to detect any changes to database
From: trub3101 <trub3101_at_sky.com>
Date: Mon, 9 Feb 2009 02:11:25 -0800 (PST)
Message-ID: <7d27ff0c-03d0-4247-94ec-fe55070913e0_at_h16g2000yqj.googlegroups.com>
On 27 Jan, 20:20, Eric Junkermann <e..._at_deptj.demon.co.uk> wrote:
> On 2009-01-27, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
>
>
>
>
>
>
>
> > 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.
>
> 5.1.22 - now that's a while ago. I was there. Auditing? Yes, I think
> you're right. But the memories are getting a little faded, and I wasn't
> particularly interested in auditing at the time.
>
> The OP didn't make it particularly clear whether it was data changes or
> schema changes that were the issue though, and it does affect the
> answer.
>
> OP, please elaborate.
>
> E.- Hide quoted text -
>
> - Show quoted text -
Date: Mon, 9 Feb 2009 02:11:25 -0800 (PST)
Message-ID: <7d27ff0c-03d0-4247-94ec-fe55070913e0_at_h16g2000yqj.googlegroups.com>
On 27 Jan, 20:20, Eric Junkermann <e..._at_deptj.demon.co.uk> wrote:
> On 2009-01-27, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
>
>
>
>
>
>
>
> > 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.
>
> 5.1.22 - now that's a while ago. I was there. Auditing? Yes, I think
> you're right. But the memories are getting a little faded, and I wasn't
> particularly interested in auditing at the time.
>
> The OP didn't make it particularly clear whether it was data changes or
> schema changes that were the issue though, and it does affect the
> answer.
>
> OP, please elaborate.
>
> E.- Hide quoted text -
>
> - Show quoted text -
Hi,
I must admit I have not logged into my profile for a little while. Not really an issue, but I was talking about schema changes.
Thanks,
tb3101
Received on Mon Feb 09 2009 - 04:11:25 CST