Archiving System for Oracle

I am orking for a team that currently designes a database-solution for an inshurence company. The security and revisioning people of this company want, that for any update of this database the old values are stored in some kind of archive. This archive will probably not needed very often but it must be possible to find out all values of the database for any time in past.

My Idea is to implement a second Oracle instance with the same structure as the productive database and an additional timestamp field in every table. On every table of the productive database will be a trigger that copies the old-data to the archive database.

Does anybody use a system of that kind -- or tested a system like that and run into troubles. I would like to hear of your expiriences. Thank you

Olaf Received on Mon Jun 22 1998 - 13:45:40 CDT