Tài liệu Sybex OCA Oracle 10g Administration I Study Guide phần 10

Earlier in this chapter, in the section “User Error Failures,” we presented a number of scenarios
in which a user’s data was inadvertently changed or deleted or a table was dropped. In the following
sections, we’ll show you how to use Flashback Query to retrieve selected rows from a
previous state of a table, how to recover a table using Flashback Drop and a tablespace’s recycle
bin, how to bring back an entire table and its dependent objects (such as indexes) back to a point
of time in the past using Flashback Table, and query previous transactions in the online and
archived redo logs using the LogMiner utility.