Skip Headers Oracle® Database SQL Language Reference 12c Release
1 (12.1)  Go to Documentation Home Go to Book List Book List Go
to Table of Contents Go to Index Go to Master Index Master Index
Go to Feedback page Contact Us  Go to previous page Go to next
page PDF · Mobi · ePub      Oracle strongly recommends that you
run your database in automatic undo mode by leaving the
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 the oldest data
you anticipate needing. For more information refer to the
documentation on the UNDO_MANAGEMENT and UNDO_RETENTION
initialization parameters.   See Also:    Row movement must be
enabled for all tables in the Flashback list unless you are
flashing back the table TO BEFORE DROP. That operation is called
a flashback drop operation, and it uses dropped data in the
recycle bin rather than undo data. Refer to row_movement_clause
for information on enabling r