6.8. Exam Essentials
Know how to recover a dropped table using Flashback Drop. Make sure you are aware of how the Recycle Bin works for dropped objects. You should be able to identify objects in the Recycle Bin. You should be familiar with how to manage the Recycle Bin and be able to perform a Flashback Drop recovery of a dropped object.
Know how to recover from user errors with Flashback Versions Query. Know how to perform a Flashback Versions Query using timestamp or SCN information. Be aware of how undo data is used with Flashback Versions Query and how to protect this data. You should also know how to identify data with pseudocolumns.
Be aware of how to perform a transactional level recovery using Flashback Transaction Query. Know how to ...
Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
