Oracle Error ORA-28659: COMPRESS must be specified at object level first

Oracle Error Message

ORA-28659: COMPRESS must be specified at object level first

Reason for the Error

Attempt to specify COMPRESS at partition level without first specifying at the table level

Solution

Specify COMPRESS at table level. Use ALTER TABLE xxx MODIFY DEFAULT ATTRIBUTES COMPRESS …