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

Error Type: ORA

• Additional information for ORA-28665: table and partition must have same compression attribute28665
Discussions and solutions for Oracle Database Error ORA-28665: table and partition must have same compression attribute Developer anwers for Oracle Database Error ORA-28665: table and partition must have same compression attribute FAQs for ORA-28665: table and partition must have same compression attribute search others tips for ORA-28665: table and partition must have same compression attribute