Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Flashback Table

user545194Jan 17 2023

Hi,
Env: Oracle 19c SE2
We have the following undo settings:
undo_retention integer 9000 and db_flashback_retention_target integer 1440
I was able to restore a table with flashback table that was deleted way before the undo retention time. Does this mean that as long as the table is in the recyclebin it can be restored regardless of time of deletion?

This post has been answered by asahide on Jan 17 2023
Jump to Answer
Comments
Post Details
Added on Jan 17 2023
3 comments
307 views