6.420 USER_FLASHBACK_ARCHIVE
USER_FLASHBACK_ARCHIVE
describes flashback data archives, which consist of multiple tablespaces and historic data from all transactions against tracked tables.
The content of this view depends on the privileges of the user who queries it, as follows:
-
If the user has the
FLASHBACK ARCHIVE ADMINISTER
system privilege, thenUSER_FLASHBACK_ARCHIVE
describes the flashback archives for all users who have been granted theFLASHBACK ARCHIVE
object privilege. -
If the user does not have the
FLASHBACK ARCHIVE ADMINISTER
system privilege, thenUSER_FLASHBACK_ARCHIVE
describes flashback archives for which the current user has been granted theFLASHBACK ARCHIVE
object privilege.
The columns of the USER_FLASHBACK_ARCHIVE
view are the same as those in DBA_FLASHBACK_ARCHIVE
.
See Also: