automated history with Oracle?

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 Received on Thu May 04 2006 - 10:46:54 CDT