怎么避免在线move发生的问题,查看资料说8i,对于index organized tables , You can rebuild these online.
对于9i可以支持在线move 和rebuild(在read and WRITE 该对象时)
但是我测试的结果是
session1
set autot traceonly
select * from move;
session2(在session1执行期间)
SQL> altertable move move;
altertable move move
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
再看
session1
altertable move move ;
session2
SQL> update move set object_id = object_id +1000000;
update move set object_id = object_id +1000000
*
ERROR at line 1:
ORA-01502: index 'T.MOVE_IND' or partition of such index is in unusable state
这里还没来得及rebuild index
alter index move_pk rebuild;
SQL> update move set object_id = object_id +1000000;
75510 rows updated.
然后我看一下9i支持的在线move
SQL> alter table move move online
2storage (initial 12k
3 next 128K
4 minextents 1
5 maxextents unlimited
6 pctincrease 0);
alter table move move online
*
ERROR at line 1:
ORA-01735: invalid ALTER TABLE option
还是不行,大家有没有办法在产品库上做move和rebuild操作