ORA-14402: updating partition key column would cause a partition change
由上一个分区表的问题，引出了另外一个问题ORA-14402
在update更新分区表的分区键的值的时候，需要开启row movement功能，否则会报错
SQL> update par_goolen set created=sysdate where created < sysdate -365;
update par_goolen set created=sysdate where created < sysdate -365
*
ERROR at line 1:
ORA-14402: updating partition key column would cause a partition change
SQL> alter table par_goolen enable row movement;
Table altered.
SQL> update par_goolen set created=sysdate where created < sysdate -365;
49954 rows updated.
SQL> alter table par_goolen disable row movement;
Table altered.
在update更新分区表的分区键的值的时候，需要开启row movement功能，否则会报错
SQL> update par_goolen set created=sysdate where created < sysdate -365;
update par_goolen set created=sysdate where created < sysdate -365
*
ERROR at line 1:
ORA-14402: updating partition key column would cause a partition change
SQL> alter table par_goolen enable row movement;
Table altered.
SQL> update par_goolen set created=sysdate where created < sysdate -365;
49954 rows updated.
SQL> alter table par_goolen disable row movement;
Table altered.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23249684/viewspace-1389429/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Oracle备库丢失数据文件导致复制进程异常
- rman增量恢复DG备库出现GAP的情况
- mysqldump: Got error: 1356: View 'goolen.v_dbstatus' references invalid
- 启动apache报错httpd: apr_sockaddr_info_get() failed for goolen
- PHP编译报错error: libjpeg.(a|so) not found.
- Python升级后yum报错No module named yum
- Lepus监控-WEB管理台安装
- Lepus监控-采集器安装
- Lepus监控-python基础模块安装
- ERROR 1827 (HY000): The password hash doesn't have the expected format
