SQL> create table t(x int) partition by range(x) (partition p1 values less than(10), partition p2 values less than(maxvalue));
SQL> insert into t select object_id from dba_objects;
SQL> update t set x=x+1 where x<5000;
ora-14402:更新分区关键字列将导致分区的更改
SQL> alter table t enable row movement;
SQL> update t set x=x+1 where x<5000;
已更新4940行。
阅读(476) | 评论(0) | 转发(0) |
