Configuring Flashback Technologies

Oracle 12c    |    Intermediate
  • 9 videos | 41m 7s
  • Earns a Badge
The Oracle Flashback technologies let you view past states of database objects or return objects to a previous state. Examine various Flashback technologies, and how to configure and use them.

WHAT YOU WILL LEARN

  • Describe the flashback technologies available in an oracle database
    Configure undo retention
    Use flashback query and flashback version query
    Describe the flashback table feature
    Use flashback table to reverse a rogue transaction
  • Describe the flashback transaction query feature
    Use the flashback transaction query feature
    Describe flashback drop and how the recycle bin works
    Flash back a dropped table

IN THIS COURSE

  • Locked
    1.  Understanding the Flashback Technologies Available
    4m 25s
    Upon completion of this video, you will be able to describe the flashback technologies available in an Oracle database. FREE ACCESS
  • Locked
    2.  Configuring an Oracle 12c Database to Support Flashback
    4m 18s
    During this video, you will learn how to configure undo retention. FREE ACCESS
  • Locked
    3.  Using the Flashback Query and Version Query Features
    4m 33s
    During this video, you will learn how to use Flashback Query and Flashback Version Query. FREE ACCESS
  • Locked
    4.  Understanding the Flashback Table Feature
    4m 7s
    After completing this video, you will be able to describe the Flashback Table feature. FREE ACCESS
  • Locked
    5.  Using the Flashback Table Feature
    3m 55s
    To reverse a rogue transaction, find out how to use Flashback Table. FREE ACCESS
  • Locked
    6.  Understanding the Flashback Transaction Query Feature
    3m 42s
    Upon completion of this video, you will be able to describe the Flashback Transaction Query feature. FREE ACCESS
  • Locked
    7.  Using the Flashback Transaction Query Feature
    6m 2s
    Learn how to use the Flashback Transaction Query feature. FREE ACCESS
  • Locked
    8.  Understanding Flashback Drop and the Recycle Bin
    4m 15s
    Upon completion of this video, you will be able to describe how Flashback Drop works and how the recycle bin works. FREE ACCESS
  • Locked
    9.  Restoring  a Dropped Table Using Flashback Drop
    5m 51s
    Learn how to rollback a dropped table. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel SQL Database Development & Design
Course Using Flashback Technologies
Course Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Memory Tuning Techniques
Course Recovery Configuration
Course Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)