in reply to Re: database historisation
in thread database historisation

Thanks, what you propose is almost exactly what I have been experimenting on earlier today.

Tom Kyte (an Oracle-Guru) however discourages the use of triggers here in favor of a specific Oracle technology, but as I have no experience with Oracle Workspace Manager I'll take your word that such a trigger-approach is tried and tested :-)

Replies are listed 'Best First'.
Re^3: database historisation
by roboticus (Chancellor) on Apr 18, 2009 at 13:50 UTC
    morgon:

    That flashback data archive technology certainly looks like it would do the trick. I probably need to update my Oracle knowledge, and then look over the new features of SQL Server 2008 and see if there are similar methods available there.

    ...roboticus
[reply]

In Section Seekers of Perl Wisdom