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