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



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

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06708: TLI Driver: message receive failure

1 Answers  


RMAN-03035: Debugging turned off

1 Answers  


ORA-17619: max number of processes using I/O slaves in a instance reached

1 Answers  


ORA-12421: different size binary labels

1 Answers  


DRG-13310: index owner does not have EXECUTE privilege on USER_LEXER stored procedure string

1 Answers  


TNS-04005: Unable to resolve address for string.

1 Answers  


SQL-02136: Invalid NCHAR character set id

1 Answers  


ORA-12064: invalid refresh sequence number: string

1 Answers  


RMAN-08036: channel string: could not create controlfile record for string string

1 Answers  


RMAN-06536: BACKED UP ... TIMES option is supported only for archived logs

1 Answers  


ORA-27043: unable to seek to beginning of file

1 Answers  


ORA-31180: DOM Type mismatch in invalid PL/SQL DOM handle

1 Answers  


Categories