Hi Experts, one more question on Flashback. I have one small table with 100 rows only. It has updates on every batch run. And suppose a batch aborts we want to flashback this. So, enabled the row movement on this table. And it helps to restore the data of this table. And it is very effective. But the question is can this flash back (row movement at table level) also after the entire DB restore?
Or on the DB restore it will erase the logs and cannot flashback before the restore time?
If you want to flashback to say 8:00AM and you restore to 9:00AM, you should still be able to flashback.
If you open the database with resetlogs, you probably cannot flashback to a point before that time.
Again, never tried. Might be an interesting experiment. If you absolutely need to know: I would set up a sample database and try it.