Flashback Query features can be accessed directly from the Oracle SQL language. In this video, see Oracle Flashback Query in action for the first time and learn how to view previous states data in your tables using the AS OF TIMESTAMP clause in a regular SQL statement.
- [Instructor] We will start our journey of exploring…Oracle Flashback Technologies with Flashback Query,…which is a special subset of Oracle Flashback features,…allowing us to use SQL language and retrieve previous…data from our database tables.…Flashback Query, if your remember,…relies on data stored within Oracle's UNDO tablespace.…Using Flashback Query is actually very simple.…Let's see an example.…We will start by connecting to the demo_pdb database…which we created earlier in our course.…
So I'll type system/oracle@localhost:1521/demo_pdb,…which is the plug-able database…I want to open my connection to.…We'll also need to create a sample table for our example.…You can find a create table statement…provided in your exercise file.…So let's copy this command,…and paste it into our SQL path window.…
Ask you can see, I'm creating a flashback_query_test table…located in the demo01 schema.…This is a very straight forward table…and only contains two columns for simplicity sake.…After creating the table, and for our example to work…
- Complete vs. incomplete recovery
- Point-in-time recovery
- Failure categories
- Preparing the virtual machine
- Performing user-managed backups
- Restoring from manual backups
- Performing full and incremental backups with RMAN
- Recovering a PDB and CDB
- Exporting and importing data with Oracle Data Pump
- Performing logical backups with Data Pump
- Using Flashback Query, Table, and Database
- Creating restore points
Skill Level Intermediate
Oracle 12c Database: Administrationwith David Yahalom3h 58m Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
1. Backup and Recovery Core Concepts
2. Failure Categories and Backup Types
3. Preparing the Course VM
4. User-Managed Backups
5. Recovery Manager (RMAN)
6. Oracle Data Pump
7. Oracle Flashback
What's next?2m 7s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.