A colleague deleted an important Oracle table and failed to run the project! Fortunately, a DBA friend of mine suggested that oracle's flashbacktable can restore data
A colleague deleted an important Oracle table and failed to run the project! Fortunately, a DBA friend suggested that the flashback table of oracle can restore data
A colleague deleted an important Oracle table and failed to run the project! Fortunately, a DBA friend suggested that the flashback table of oracle can restore data. After using the flashback table, the results will be good and we will learn it together! Here, I would like to thank my DBA friends !!!
// Set the rows that can be moved by the outer table.
1. alter table T_DUAL enable row movement;
// Execute the restore operation for the table data from 20011 to 02-23 22:53:00
2. flashback table T_DUAL to timestamp TO_TIMESTAMP ('2017-02-23 22:53:00 ', 'yyyy-mm-dd hh24: mi: ss ');