Oracle Oracle FLASHBACK

Oracle FLASHBACK

Catalog: Oracle
Short name: Oracle FLASHBACK
Course start date: 2024-07-02
Paystack
Enroll Me

Description

Oracle Flashback Technology is a group of Oracle Database features that that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery.Oracle Oracle Flashback features use the Automatic Undo Management (AUM) system to obtain metadata and historical data for transactions. They rely on undo data, which are records of the effects of individual transactions. For example, if a user executes an UPDATE statement to change a salary from 1000 to 1100, then Oracle Database stores the value 1000 in the undo data.

Course Duration:-3h 24m

Sections

General
0 activities

Overview and Undo Management
Accidental Delete Scenario
Flashback Delete and Update
Archive Log Mode Being Enabled
Version Query Delete Commit
Transaction Query
Transaction Query continued
Table Theory
Table To Timestamp Lab Example
Table To Restore Point Lab Example
Behavior of Index during Flashback Table Operation
Flashback Table to Before Drop Theory
Flashback Table to Before Drop Theory continued
Flashback Table to Before Drop - Simple Example
Flashback Table to Before Drop - Truncate Table
Flashback Table to Before Drop - Same Table Dropped Multiple Times
Flashback Database Concepts‚ Restrictions and Effects on Datafile
Database Concepts‚ Restrictions and Effects on Datafile continued
State of the Database and Flashback Log Mode Being Enabled
Database To SCN - Simple Example
Normal vs Guaranteed Restore Points
Concepts‚ Creation‚ Alteration‚ Dropping of Flashback Data Archives
Concepts‚ Creation‚ Alteration‚ Dropping of Flashback Data Archives continued
Assigning of Tables in various flashback data archive objects
Flashback Transaction
Course Certificate
Secure Video
25
Certificate
1
Cost: 5000
Enroll Me

Tag

Course Duration:-3h 24m