We use a 72-hour undo retention time. This allows for reasonable time
to do a flashback query if necessary. Like Daniel said, it's a
no-brainer. Just having flashback alone is worth it to me. It saved
me a lot of work one day when a bug in one of our apps cause a "DELETE
FROM xxx" to be executed on one of our tables. Being able to flashback
the data to another table (clone of original) and then grab what I
needed was a lot faster than having to restore the table, etc.
Jesse
Received on Wed Apr 06 2005 - 08:45:51 CDT
