Using Flashback Technology in Oracle 10g
Overview/Description
To outline the considerations and procedures for using Flashback features
Target Audience
Oracle database administrators and database operators
Prerequisites
Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL
Expected Duration
160 Minutes
Objectives:
Using Flashback Technology in Oracle 10g
recognize situations that are suited to the use of Flashback Database.
execute a Flashback Database operation.
enable Flashback features and perform a Flashback Database operation.
identify the recommended steps to perform a Flashback Table operation in a given scenario.
identify the appropriate Flashback Query feature to be used for given scenarios.
use Flashback features to audit and fix tables.
use the Recycle Bin to perform a Flashback Drop operation and to purge items.
determine suitable uses of appropriate Flashback features for given scenarios.
Course Number: 212481_eng