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
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
No comments:
Post a Comment