053-677

What are the prerequisites for performing flashback transactions? (Choose all that apply)
A.Supplemental log must be enabled
B.Supplemental log must be enabled for the primary key
C.Undo retention guarantee for the database must be configured
D.”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user

执行闪回事务先决条件:
1、数据库必须位于归档模式。
2、附加日志必须开启,在数据库级别和在要进行闪回事务表上主键级别(最少)开启。
3、 SYS 之外的用户需要有执行 DBMS_FLASHBACK 和 SELECT ANY TRANSACTION 的权限。

posted @ 2017-11-15 14:56  巴啦啦大魔王  阅读(121)  评论(0编辑  收藏  举报