Oracle Error ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

Oracle Error Message

ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

Reason for the Error

COMPRESS was specified more than once, NOCOMPRESS was specified more than once, or both COMPRESS and NOCOMPRESS were specified.

Solution

specify each desired COMPRESS or NOCOMPRESS clause option only once.