You are here: Home // Oracle 11g // ORA-28665: table and partition must have same compression attribute

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 See the solution below.

Error solution: Make sure the compression attributes match If they don't, fix it using ALTER TABLE MOVE [PARTITION] COMPRESS

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: znaki drogowe zarządzanie stresem szkolenia Dieta Kopenhaska bmw transport kraków