177. On Monday, you dropped the DEPT table from your schema and then
you re-created the DEPT table in your schema. On Wednesday, you have
a requirement to restore the DEPT table from the recycle bin. Which s
tatement is correct?
A. You cannot restore the DEPT table by using the Oracle Flashback Dr
op feature because a table with the name DEPT already exists in your
schema.
B. You can restore the DEPT table by using the Oracle Flashback Drop
feature, provided you use the RENAME TO clause.
C. You cannot restore the DEPT table by using the Oracle Flashback Dr
op feature because the contents of the recycle bin are purged every 1
2 hours by default.
D. You can restore the DEPT table by using the Oracle Flashback Drop
feature and a system-generated name will be assigned to the restored
table.
Answer: B
Flashback table 语句同时提供了一个rename to 的子句，如果要恢复的表
在当前的schema 中已经,存在同名的表，建议你在恢复时通过rename to 子句为
待恢复的表指定一个新的表名，不然数据库会报ORA-38312
Flashback table DEPT2 to before drop rename to dept
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718240/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
