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-09831: snyStartThread: failed to build the server port set.

1 Answers  


PLS-00562: a function must return a type.

1 Answers  


ORA-38470: cannot revoke a privilege that was not granted.

1 Answers  


ORA-32800: internal error string

1 Answers  


PLS-00585: declared support library for opaque type is not a library

1 Answers  






QSM-01077: materialized view, string, is grouping at a higher level than query

1 Answers  


PCB-00901: Pro*COBOL internal error condition detected (Code = number)

1 Answers  


ORA-24192: the property name cannot be null

1 Answers  


ORA-30159: OCIFileOpen: Cannot create the file or cannot open in the requested mode

1 Answers  


QSM-01582: Joining equivalence, string, with table, string, not possible

1 Answers  


DRG-11723: phrase cannot be NULL

1 Answers  


ORA-01282: date range specified is invalid

1 Answers  


Categories