ORA-14402: updating partition key column would cause a partition change
来源:互联网 发布:淘宝匿名购买好不好 编辑:程序博客网 时间:2024/05/29 16:25
问题描述
当更新分区表的分区键时,会出现ORA-14402错误。
演示:
表t_order_photo 是按照EDATE为分区键的分区表。
SQL> update t_order_photo t 2 set t.edate=sysdate,editor='Alen',photo_status=0 3 where t.id=611;update t_order_photo t *ERROR at line 1:ORA-14402: updating partition key column would cause a partition change
解决办法
对该表启用行移动。
演示:
SQL> alter table t_order_photo enable row movement;Table altered.SQL> update t_order_photo t 2 set t.edate=sysdate,editor='Alen',photo_status=0 3 where t.id=611;1 row updated.SQL>
阅读全文
0 0
- ORA-14402: updating partition key column would cause a partition change
- ORA-14402:updating partition key column would cause a partition change
- updating partition key column would case a partition change
- How To Change the Partition Column Of A Partitioned Table Using DBMS_Redefinition [ID 846405.1]
- How To Change the Partition Column Of A Partitioned Table Using DBMS_Redefinition [ID 846405.1]
- partition key
- mysql分区表----column partition
- ORA-14400: inserted partition key does not map to any partition
- ORA-14400: inserted partition key does not map to any partition
- ORA-14400: inserted partition key does not map to any partition
- Partition
- PARTITION
- partition
- partition
- partition
- Partition
- partition
- partition
- 【Linux】启动顺序
- ObjectTypeExample 引用类型的值"对象"是引用类型的实例JavaScript
- 小练习
- Java特性多态
- 解决网站项目本地运行ok,将代码上传到服务器中或github中无CSS效果
- ORA-14402: updating partition key column would cause a partition change
- 凸集合
- 正则表达式学习积累
- 接口回调
- mybatis2-关于mybatis在实际开发中到底是选用xml还是注解的解释
- 网页 滤镜
- 查看linux系统版本信息以及cpu信息
- 简易计时器
- NDK 与 JNI 的关系以及调用流程