關於Partition列被更新的問題

一、

今天遇到這樣一個問題:

Error Msg is ORA-14402: updating partition key column would cause a partition change

解決辦法為:

alter table owner.table_name enable row movement;

二、

SQL> create table ttt(a number)
2 partition by range(a)
3 (partition p1 values less than (10),
4 partition p2 values less than (20));

Table created.

SQL> insert into ttt values(1);

1 row created.

SQL> commit;

Commit complete.

SQL> update ttt set a=13 where a=1;
update ttt set a=13 where a=1
*
ERROR at line 1:
ORA-14402: updating partition key column would cause a partition change


SQL> alter table ttt enable row movement;

Table altered.

SQL> update ttt set a=13 where a=1;

1 row updated.

SQL> commit;

Commit complete.

SQL>

補充：

最好不要對需要UPdate的列進行分割槽；

好像只有到了Oracle8i才開始支援enable row movement這個子句的。

在Oracle8裡面沒有這樣的功能。

[@more@]