How to fix the Oracle error ORA-28665: table and partition must have same compression attribute?

In this post, you’ll learn more about the Oracle ErrorORA-28665: table and partition must have same compression attribute with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-28665: table and partition must have same compression attribute

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

How to fix the Error ORA-28665: table and partition must have same compression attribute ?

You can fix this error in Oracle by following the below steps

Make sure the compression attributes match If they don’t, fix it using ALTER TABLE MOVE [PARTITION] COMPRESS