168. You are working on an Oracle Database 10g database that operates
in the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table i
n the SYSTEM tablespace that does not belong to the data dictionary w
as dropped at 03:00 p.m. What would you do to recover the table?
A. use the Flashback Transaction Query feature to identify the releva
nt SQL statement and use it to undrop the table
B.restore the entire database from the most recent backup and open it
C. recover the table by using the Flashback Table feature
D. perform. point-in-time recovery to recover the table
Answer: D
对应C 选项,只能在非系统表空间下使用 Flashback Table(利用回收站)
sys 用户下的数据不支持闪回查询
truncate 不支持闪回查询
闪回查询,利用的是undo 空间
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718230/,如需转载,请注明出处,否则将追究法律责任。