ORA-28665: table and partition must have same compression attribute

ORA-28665: table and partition must have same compression attribute
Cause: User attempted to EXCHANGE a compression enabled partition with a compression disabled table or vice versa OR the # of columns compressed is different for table and partition
Action: Make sure the compression attributes match If they don't, fix it using ALTER TABLE MOVE [PARTITION] COMPRESS

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-28665：表和分区必须具有相同的压缩属性,
.原因：用户尝试使用禁用压缩表来EXCHANGE启用压缩的分区，反之亦然或者表和分区的压缩列数不同,
.操作：确保压缩属性匹配如果它们不匹配，请使用ALTER TABLE MOVE [PARTITION] COMPRESS修复它,
.

aiaiDBA

13718043309

010-86462881

ORA-28665: table and partition must have same compression attribute

1 个回答

相似问题