Re: Does Oracle Have a Way to Store Historical Changes to Records?

Paul apparently said,on my timestamp of 4/08/2005 9:03 PM:
> Is there not some simple way to switch on the auditing functionality
> of Oracle?
>
> Nobody seems to have mentioned it as a possibility. I was of the
> understanding that this sort of thing could be done automatically
> without having to hand code triggers &c.
>
> Explanations?

Auditing is still there, so is FGA (fine grain audit). But it won't let you reconstruct the past history of the row. For that I think you need either custom code or the WM stuff pointed out by Maxim.

(and I'm sure glad no one mentioned Flashback yet!...)

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam