Flashback a table in oracle database

Oracle strongly recommends that you run your database in automatic undo mode by leavingthe UNDO_MANAGEMENT initialization parameter set to AUTO, which is the default. In addition,set the UNDO_RETENTION initialization parameter to an interval large enough to include theoldest data you anticipate needing. For more information refer to the documentation on the UNDO_MANAGEMENT and UNDO_RETENTIONinitialization parameters […]