Database Backup and Recovery (MOSC)

MOSC Banner

Where does Flashback Table get its information from when Flashback is enabled

edited May 5, 2010 4:10AM in Database Backup and Recovery (MOSC) 3 commentsAnswered
I have a table with row movement enabled and also have the Database instance with Flashback on. I understand that flashback database uses flash_recovery_area and that the flsahback before drop uses the recyclebin.

My ambiguity is on the standard flashback table to a restore point. where does oracle get its recovery data from ? is it from UNDO or from the flash recovery area ?

How do i size for Flashback table ? should i be sizing the UDO or the flash_recovery_area

 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center