Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-28665: table and partition must have same compression attribute
Oracle® Database Error ORA-286651386/18

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

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle