db_flashback_retention_target and undo_retention

[satish]

Dear Erman,

The undo_retention is used for read consistency, to avoid snapshot too old.Flashback database is using files in the db_recovery_file_dest.But whether undo_retention has any influence on Flashback drop; Flashback table or Flashback query?Let's say we have set undo_retention = 3600 = 1 hour.And

db_flashback_retention_target = 1440 = 24 hours.

Will it work Flashback drop; Flashback table; Flashback query to get 12 hours back?

Thank you

[ErmanArslansOracleBlog]

Flashback database and other operations like flashback query relies on different thing.
Flashback database is controlled relies on flashback logs in the fast_recovery_area, and can be controlled using db_flashback_retention_target.
Flashback table and query features rely on undo and can be controlled by undo parameters..undo_retention, undo size etc.

[satish]

Does Flashback table and query features require flashback rentention target and flashback recovery area size parameters to be set?

[ErmanArslansOracleBlog]

Flashback table and query features rely on undo and can be controlled by undo parameters..undo_retention, undo size etc.

To enable" Flashback Database", you set up a flash recovery area, and set a flashback retention target.