Using Oracle Flashback Features
The final section of this chapter includes exercises that provide you with some fundamental experience using a couple of Oracle's Flashback recovery features: Flashback Drop and Flashback Table. These features are useful when you need to recover data lost due to logical data errors or corruptions rather than physical storage problems.
EXERCISE 9.25: Restore a Dropped Table Using Oracle Flashback Drop
This exercise teaches you how to recover from an all-to-common problem: someone has mistakenly dropped a table. Rather than perform a complicated database recovery operation to restore the lost table, you can use Oracle's Flashback Drop feature. As explained in the section "Logical Errors and Oracle Flashback" earlier ...
Get Hands-On Oracle Database 10g Express Edition for Windows 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.
