ORA-14402的处理

SQL> 

SQL> create table test_part(id number(10),name varchar2(100),cdate date)        

  2  partition by range(cdate)

  3  

SQL> 

SQL> create table test_part(id number(10),name varchar2(100))

  2  partition by range(id)

  3  (partition p1 values less than(10),

  4  partition p2 values less than(20),

  5  partition p3 values less than(30)

  6  );

Table created.

SQL> insert into test_part values(1,'aa');      

1 row created.

SQL> insert into test_part values(15,'bb');

1 row created.

SQL> insert into test_part values(25,'cc');

1 row created.

SQL> commit;

Commit complete.

SQL> update test_part set id=9 where id=15;

update test_part set id=9 where id=15

       *

ERROR at line 1:

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

SQL> alter table test_part enable row movement;

Table altered.

SQL> update test_part set id=9 where id=15;

1 row updated.

SQL> commit;

Commit complete.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23718752/viewspace-767334/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23718752/viewspace-767334/