926840 wrote:Flash Back Table,Flash Back Version Query , Flash Back Transaction Query are alls Flash Back Technology which uses Undo tablespaces and honored by Undo_Retention period ,from these technolgies you can restore deleted rows from tables.
Done..when i use the dba_recyclebin object it show the recycle object in recycle bin.
My another question is how old we go back for e.g if i delete some rows and drop the table in database.
then why we need undo_retention in flashback technology.Because entire Flashback technology is based on Undo data only, except Flashback database, which requires Flashback log and whose related parameter db_flashback_retention_target; thats why if someone asks something like
926840 wrote:As the name reveals that flashback "in literature and dramatic media, an interjected scene that takes the narrative back in time from the current point " , to flashback in database what should you have to go back.It makes sound for me some recorder to back the past.This recorder could be Undo (which honored by Undo_Retention , to make yourself own disposal to accomodate how far you wana back) , it is how designed by Oracle , i could not comments over it.To flashback whole database does not make sense to honored by Undo , yes it does by flashback logs and archivelogs which honored by db_flashback_retention_target.
Thanks alot sir,but clarify one more thing then why we need undo_retention in flashback technology.