053392

To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?
A. TRUNCATE the archive table.
B. DROP the Flashback Data Archive.
C. Nothing; expired rows are automatically removed.
D. Nothing; expired rows are moved to an archive table.
E. Delete entries from the archive where the metadata date retained is greater than the retention period.

  Do nothing.Once the retention period has passed,rows will be automatically removed from the Flashback Data Archive.TRUNCATE on a table that is archived is not allowed.Dropping the archive will definitely clear the old records,but it will also eliminate the ones you wanted to keep.

原文地址:https://www.cnblogs.com/Babylon/p/7827384.html