A. Ensure that database is running with version 10.1 compatibility.
B. Enable Flashback Logging.
C. Enable Supplemental Logging.
D. Ensure that the database is running with version 10.0 compatibility.
E. Ensure that the database is in ARCHIVELOG mode
答案:(C、D)
解析:
《Advanced Application Developer's Guide》 12.2.2
为了闪回事务查询,要求:
1. COMPATIBLE >= 10.0
2. 开启补充日志:ALTER DATABASE ADD SUPPLEMENTAL LOG DATA