Skip Headers
Oracle® Database SQL Language Reference
11g Release 1 (11.1)

Part Number B28286-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DROP FLASHBACK ARCHIVE

Purpose

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.

Prerequisites

You must have the FLASHBACK ARCHIVE ADMINISTER system privilege to drop a flashback data archive.

Syntax

drop_flashback_archive::=

Description of drop_flashback_archive.gif follows
Description of the illustration drop_flashback_archive.gif

Semantics

flashback_archive

Specify the name of the flashback data archive you want to drop.

You cannot drop the default flashback data archive unless it has been disabled for all tables for which historical tracking is enabled with this flashback data archive.

See Also:

CREATE FLASHBACK ARCHIVE for information on creating flashback data archives and for some simple examples of using flashback data archives