only one COMPRESS or NOCOMPRESS clause may be specified

Solution ID:ORA-14460

Type: Oracle

Cause

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

Actions

Do not specify these datatypes for temporary tables.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/10441480


https://community.oracle.com/message/9712141


https://community.oracle.com/message/4373051


Browse all solutions to database errors from Oracle, MS SQL, or MySQL