Oracle® Database SQL Language Reference 11g Release 2 (11.2) E41084-02 |
|
|
PDF · Mobi · ePub |
Use the DROP
FLASHBACK
ARCHIVE
clause to remove a flashback data archive from the system. This statement removes the flashback data archive and all the historical data in it, but does not drop the tablespaces that were used by the flashback data archive.
You must have the FLASHBACK
ARCHIVE
ADMINISTER
system privilege to drop a flashback data archive.
Specify the name of the flashback data archive you want to drop.
See Also:
CREATE FLASHBACK ARCHIVE for information on creating flashback data archives and for some simple examples of using flashback data archives