ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?
A. Because row IDs may change during the flashback operation
B. Because the object number changes after the flashback operation
C. Because the rows are retrieved from the recyclebin during the flashback operation
D. Because the table is moved forward and back to a temporary during the flashback operation
答案:(A)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1327952/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1327952/
在进行闪回表操作前,执行ALTER TABLE employees ENABLEROWMOVEMENT命令的原因在于rowIDs可能在操作期间改变。这是因为闪回操作可能会导致对象编号的变化,从回收站检索行,或者在操作过程中表被临时移动。

1万+

被折叠的 条评论
为什么被折叠?



