updating partition key column would case a partition change
来源:互联网 发布:php只能做网站吗 编辑:程序博客网 时间:2024/06/03 21:31
这个主要是对分区的字段进行了更改, 导致该行需要移至另一个分区
在Oracle中,如果数据量大,一般会使用多个表分区,建表方式为:
create table table1(
logID NUMBER(18) not null,
CreateTime DATE default(sysdate),
)
PARTITION BY RANGE (CreateTime)
( PARTITION part1
VALUES LESS THAN (TO_DATE('2005-01-01','YYYY-MM-DD'))
TABLESPACE tablespace1,
PARTITION part2
VALUES LESS THAN (TO_DATE('2005-02-01','YYYY-MM-DD'))
TABLESPACE tablespace1,
PARTITION part3
VALUES LESS THAN (TO_DATE('2005-03-01','YYYY-MM-DD'))
TABLESPACE tablespace1)
当使用这样的结构的时候,如果在原有数据上进行Update操作,而Update操作恰恰是修改CreateTime这样的
用来区分表分区的字段,那么将可能出现错误:
原纪录是2005-01-21,如果改为2005-02-21,那么将会出现错误:
ORA-14402: updating partition key column would cause a partition change
- updating partition key column would case a partition change
- ORA-14402: updating partition key column would cause a partition change
- ORA-14402:updating partition key column would cause 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
- Partition
- PARTITION
- partition
- partition
- partition
- Partition
- partition
- partition
- 重建分区表主键 - Recreate Primary Key on a partition table
- 硬盘安装助手安装苹果Mac系统镜像Change partition type to AF: not a HFS partition的解决方法
- gparted and how to change /home directory to a new partition
- VxWorks操作系统入门教程
- Rendering ink and image to a bitmap using WPF
- Linux 磁盘“Block Size”研究
- Ant [常用方法]
- C语言实现打开一个文件(有内容的),统计这个文件中字符e出现了多少次
- updating partition key column would case a partition change
- Cursor的moveToFirst和moveToNext .
- 关于Linux静态库和动态库的分析
- Firefox从HTML文件导入由360安全浏览器/IE导出的书签时的乱码问题
- Web开发人员应当收藏的10个网站
- Cheat Engine Tutorial v3--翻译Cheat Engine 6.1 tutorial(3)
- UILabel多行并根据高度动态显示文本
- 技术网站
- Android Architecture