ORA-14183: TABLESPACE DEFAULT can be specified only for Composite LOCAL index ORACLE 报错 故障修复 远程处理

文档解释

ORA-14183: TABLESPACE DEFAULT can be specified only for Composite LOCAL index

Cause: User attempted to specify TABLESPACE DEFAULT for a partition of a Range/System/Hash partitioned LOCAL index object, which is illegal.

Action: Replace TABLESPACE DEFAULT with TABLESPACE or remove it.

ORA-14183：只能为复合本地索引指定表空间默认。

官方解释

常见案例

正常处理方法及步骤

DROP INDEX IND_NAME TABLESPACE SOME_TABLESPACE;