文档解释
ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
Cause: COMPRESS was specified more than once, NOCOMPRESS was specified more than once, or both COMPRESS and NOCOMPRESS were specified.
Action: specify each desired COMPRESS or NOCOMPRESS clause option only once.
ORA-14460:只能指定一个COMPRESS 或者NOCOMPRESS声明
官方解释
一个TABLE创建语句中只能有一个COMPRESS和NOCOMPRESS选项。
常见案例
一个TABLE创建语句中包含多个COMPRESS和NOCOMPRESS选项就会出现ORA-14460, 比如:
CREATE TABLE test ( a int COMPRESS COMPRESS NOCOMPRESS );
正常处理方法及步骤
1. 确认TABLE创建语句中只包含一个COMPRESS或NOCOMPRESS选项。
2. 修改后重新执行TABLE创建语句。