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-30026: Undo tablespace 'string' has unexpired undo with string(sec) left, Undo_Retention=string(sec)

1 Answers  


NNO-00308: server will restart in number seconds

1 Answers  


LSX-00176: circular reference detected in schema component named "~S"

1 Answers  


DRG-50925: could not parse return value of PL/SQL

1 Answers  


ORA-28522: error initializing heterogeneous capabilities

1 Answers  






LFI-00145: User buffer too short.

1 Answers  


ORA-31196: XML nodes over string in size cannot be printed

1 Answers  


TNS-04207: Trace Assistant Internal ERROR: Packet Length

1 Answers  


ORA-01104: number of controlfiles (string) does not equal string

1 Answers  


ORA-23358: invalid remote user

1 Answers  


ORA-32304: materialized views with user-defined types cannot use prebuilt table

1 Answers  


ORA-07403: sfanfy: db_writers parameter not valid.

1 Answers  


Categories