Which of these operations will cause a flashback query to fail if it attempts to go back beyond the time when the operation occurred?Choose three answers.
A. ALTER TABLE SHRINK SPACE;
B. ALTER TABLE ADD ( );
C. ALTER TABLE DROP COLUMN ;
D. ALTER TABLE MOVE;
E. CREATE INDEX ON ();
Master Exam中给的答案为：B、C、E
经过试验，我发现只有C、D两个选项会导致flashback query fail。
ORA-01466: unable to read data - table definition has changed
A. ALTER TABLE
B. ALTER TABLE
C. ALTER TABLE
D. ALTER TABLE
E. CREATE INDEX
Master Exam中给的答案为：B、C、E
经过试验，我发现只有C、D两个选项会导致flashback query fail。
ORA-01466: unable to read data - table definition has changed
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11411056/viewspace-733762/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
共享锁与排他锁试验结论
请登录后发表评论
登录
全部评论
