From the course: Oracle Database 12c: Backup and Recovery

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using Flashback Table

Using Flashback Table - Oracle Database Tutorial

From the course: Oracle Database 12c: Backup and Recovery

Start my 1-month free trial

Using Flashback Table

“

- [Instructor] Oracle flashback technologies allows restoring an individual table to a previous point in time. Similarly to flashback query, the flashback table feature also relies on using data contained in the database undo tablespace to roll back changes. By using the flashback table statement, we can restore an earlier state of a database table in the event of human or application error. Let's see flashback table in action. We'll start by opening a connection as the system user to the demo_pdb pluggable database we have created earlier in our course. So, I'll type sqlplus system/oracle@localhost specifying the listener port number and a connection to be made to the demo_pdb pluggable database. We'll also need to create a new tablespace. So, let's see the location of our existing data files. I'll type select file_name from dba_data_Files. I'll also copy the directory in which the data files for this pluggable database have been created in, so let's copy this path. Going to our…

Contents