Oracle 视图 USER_FLASHBACK_ARCHIVE 官方解释，作用，如何使用详细说明
本站中文解释
_DETAILS
Oracle视图USER_FLASHBACK_ARCHIVE_DETAILS提供有关回滚档案的信息。它遍历用户拥有的回滚归档的数据库对象，并报告其相关表达式运行的详细信息。
1.查询USER_FLASHBACK_ARCHIVE_DETAILS视图:
SELECT * FROM USER_FLASHBACK_ARCHIVE_DETAILS;
2.使用USER_FLASHBACK_ARCHIVE_DETAILS视图:
可以使用此视图来查询和报告有关回滚档案的信息。例如，可以使用此视图检查指定的回滚档案能够检索哪些数据库表，当一个数据库表被添加和删除(重命名)如何影响其他数据表，以及哪些表达式被更改或重写，等等。
3.使用示例:
查询指定回滚档案中所有数据表的相关信息
SELECT * FROM USER_FLASHBACK_ARCHIVE_DETAILS WHERE ARCHIVE_NAME=”;
查询需要回滚的表达式
SELECT * FROM USER_FLASHBACK_ARCHIVE_DETAILS
WHERE OBJECT_NAME=’
官方英文解释
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 ADMINISTERsystem privilege, thenUSER_FLASHBACK_ARCHIVEdescribes the flashback archives for all users who have been granted theFLASHBACK ARCHIVEobject privilege. -
If the user does not have the
FLASHBACK ARCHIVE ADMINISTERsystem privilege, thenUSER_FLASHBACK_ARCHIVEdescribes flashback archives for which the current user has been granted theFLASHBACK ARCHIVEobject privilege.
The columns of the USER_FLASHBACK_ARCHIVE view are the same as those in DBA_FLASHBACK_ARCHIVE.
See Also:
“DBA_FLASHBACK_ARCHIVE”
