DBA_FLASHBACK_ARCHIVE_TABLES displays information about all tables in the database that are enabled for Flashback Archive.
Related View
USER_FLASHBACK_ARCHIVE_TABLES displays information about the tables owned by the current user that are enabled for Flashback Archive.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the table enabled for Flashback Archive |
|
|
|
|
Owner name of the table enabled for Flashback Archive |
|
|
|
|
Name of the flashback archive |
|
|
|
Name of the archive table containing the historical data for the user table |
|
|
|
|
Status of whether flashback archive is enabled or being disabled on the table |
See Also: