Oracle 10 Gb for table data in Flash

The interface developer reports that many duplicate data are in the user permission table. Then I deleted the table data Delete mode and modified the corresponding stored procedure so that the table data is not duplicated!

Later, we found that the pulled data has no permission. So I had to flash back to the early morning!

 

 

SQL> ALTER TABLE ba. t_power_admin enable row movement;
 
Table altered
 
SQL> flashback table ba. t_power_admin to timestamp to_timestamp ('2017-10-29 10:00:00 ', 'yyyy-mm-dd hh24: MI: ss ');
 
Flashback table ba. t_power_admin to timestamp to_timestamp ('2017-10-29 10:00:00 ', 'yyyy-mm-dd hh24: MI: ss ')
 
ORA-00604: recursive SQL Level 1 error
ORA-12801: Error Signal in parallel query server p018
ORA-01555: Snapshot old: rolled back field number 13 (name: "_ syssmu13 $") too small
 
SQL> flashback table ba. t_power_admin to timestamp to_timestamp (00:45:00 ', 'yyyy-mm-dd hh24: MI: ss ');
2;
3/
 
Flashback table ba. t_power_admin to timestamp to_timestamp (00:45:00 ', 'yyyy-mm-dd hh24: MI: ss ');
;
 
ORA-01756: the string in the quotation marks does not end properly
 
SQL> flashback table ba. t_power_admin to timestamp to_timestamp ('2017-10-30 00:45:00 ', 'yyyy-mm-dd hh24: MI: ss ');
 
Flashback table ba. t_power_admin to timestamp to_timestamp ('2017-10-30 00:45:00 ', 'yyyy-mm-dd hh24: MI: ss ')
 
ORA-00604: recursive SQL Level 1 error
ORA-12801: Error Signal in parallel query server p014
ORA-01555: Snapshot old: rolled back field number 12 (name: "_ syssmu12 $") too small
 
SQL> flashback table ba. t_power_admin to timestamp to_timestamp ('2017-10-30 10:45:00 ', 'yyyy-mm-dd hh24: MI: ss ');
 
Done
 
SQL> execute p_gather_day_m_admin;
 
PL/SQL procedure successfully completed
 
SQL>