Query all rely on undo data, records of the effects of each update to an Oracle database
and values overwritten in the update. Used primarily for such purposes as providing
read consistency for SQL queries and rolling back transactions, these undo records
contain the information required to reconstruct data as it stood at a past time and all
changes since that time.
Flashback Drop is built around a mechanism called the Recycle Bin, which Oracle
uses to manage dropped database objects until the space they occupied is needed to
store new data.
At the physical level, Oracle Flashback Database provides a more efficient direct
alternative to database point-in-time recovery. If you have datafiles which merely have
unwanted changes, then you can use Flashback Database to cause your current
datafiles revert to their contents at a past time. The end product is much like the result
of a point-in-time recovery, but is