Using Flashback Technology in Oracle 10g


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


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 (hours)
2.7

Lesson 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