1. 一般用于分区表,将row movement设置为enable,有可能发生行的物理移动,行的rowdi会变化,某一行更新时,如果更新的是分区列,并且更新后的列值不属于原来的这个分区,如果开启了这个选项,就会把这行从这个分区中delete掉,并加到更新后所属的分区。相当于一个隐式的触发器,但不会触发Insert/delete触发器。如果没有开启这个选项,更新时就会报错。
案例:
CREATE TABLE emp_rg(empno NUMBER(4) not null,
ename VARCHAR2(10),
job VARCHAR2(9),
mgr NUMBER(4),
hiredate DATE,
sal NUMBER(7,2),
comm NUMBER(7,2),
deptno NUMBER(2)) PARTITION BY RANGE(hiredate)
(PARTITION T_P1 VALUES LESS THAN (TO_DATE('1981/01/01','YYYY/MM/DD')),
PARTITION T_P2 VALUES LESS THAN (TO_DATE('1982/01/01','YYYY/MM/DD')),
PARTITION T_P3 VALUES LESS THAN (TO_DATE('1983/01/01','YYYY/MM/DD')),
PARTITION T_MAX VALUES LESS THAN (MAXVALUE)
)
SQL> UPDATE EMP_RG SET HIREDATE=TO_DATE('1981/12/17','YYYY/MM/DD') WHERE EMPNO=7369;
UPDATE EMP_RG SET HIREDATE=TO_DATE('1981/12/17','YYYY/MM/DD') WHERE EMPNO=7369
*
ERROR at line 1:
ORA-14402: updating partition key column would cause a partition change
2. 在flashback中使用,当需要使用flashback table功能时,需要首先打开row mvoement的选项,否则使用该功能也会报错
案例:
SQL> flashback table scott.emp_rg to scn 1166475;
flashback table scott.emp_rg to scn 1166475
*
ERROR at line 1:
ORA-08189: cannot flashback the table because row movement is not enabled