table flashback failed with error messgaes:ORA-00604: error occurred at recursive SQL level 1 ORA-12
accidentely delete the data from one table and tried to recover it by flashback but failed with these error message:
SQL> flashback table disbursements to timestamp (systimestamp - interval '300' minute);
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-12801: error signaled in parallel query server P008
ORA-01555: snapshot too old: rollback segment number 10 with name"_SYSSMU10_1883371306$" too small
database version is 11G
any idea about this or there is another way to recover the table data? Thanks.
SQL> flashback table disbursements to timestamp (systimestamp - interval '300' minute);
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-12801: error signaled in parallel query server P008
ORA-01555: snapshot too old: rollback segment number 10 with name"_SYSSMU10_1883371306$" too small
database version is 11G
any idea about this or there is another way to recover the table data? Thanks.
1