Oracle Solution for Error ora-28665

Solution for Oracle Error ORA-28665

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

What triggered the Error:

er 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

What should we do to fix it:

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