A. Flashback Table can be performed on system tables.
B. Flashback Table operation does not shrink the segments.
C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.答案:(B、D)
解析:
A(X),不能对系统表、远程表和fixed table 执行闪回表操作
C(X),闪回表操作使用undo还原数据,不需要用logminer来挖掘redo_sql和undo_sql