Can you flashback table into SYSTEM tablespace?

Flashback feature in Oracle database is well known to roll back the table to a specific timestamp (depends on undo retention) or to restore dropped table and many more. We must have used this flashback feature so far on application schema objects and found working without any issues. As an Oracle DBA did you configure […]

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 […]