Wednesday, October 23, 2013

Which are the potential use cases for Flashback Data Archive, introduced in Oracle 11gR1?

Flashback Data Archive is handy for many purposes. Here are some ideas:

- To audit for recording how data changed
- To enable an application to undo changes (correct mistakes)
- To debug how data has been changed
- To comply with some regulations that require data must not be changed after some time.
Flashback Data Archives are not regular tables so they can't be changed by typical users.
- Recording audit trails on cheaper storage thereby allowing more retention at less cost


Remember: Inserts do not create archive records; because they are not changes to data.

Source: Arup Nanda

No comments:

Post a Comment