Re: automated history with Oracle?

Danny Gerst wrote:
> Hi!
>
> For my project I need a history of all changed recordsets of one or more
> tables. If I change one record, the old one should be in the history.
>
> I have two choices. First of all to do it with my application. Well, I think
> that is a bad idea, because I have to do addional SQL Statements and when
> the scheme changes, I have to recompile some parts of my application.
> It sound like a perfect Job for the Oracle DB.
> The second choice I have is to build trigger and do it this way. But
> actually I have to do it again when I have to change the scheme.
>
> I wonder if it is possible to let Oracle create a history on itself. I read
> nearly a week about Redo Log. It seems that Oracle should know everything to
> create a history of all changes that has affected the scheme.
>
> Does anyone know if this is possible to create a history of all changes and
> showing the corresponding records. And then how I could do that?
>
>
> Thanks,
>
> Danny

And your Oracle version number is?
What transaction volume (bytes and tx/sec.)?

In 10g I can think of at least a half-dozen ways to do this.

Daniel Morgan
www.psoug.org Received on Thu May 04 2006 - 17:21:53 CDT