ORA-14002: only one GLOBAL clause may be specified

文档解释

ORA-14002: only one GLOBAL clause may be specified

Cause: CREATE INDEX statement contained more than one GLOBAL clause

Action: Specify GLOBAL option at most once

ORA-14002, the only one GLOBAL clause may be specified error, occurs when more than one GLOBAL clause is specified in the CREATE PUBLIC SYNONYM command.

官方解释

常见案例

正常处理方法及步骤

1.首先确认在 CREATE PUBLIC SYNONYM 命令中是否包含多个 GLOBAL 声明。

2.如果确认包含多个 GLOBAL 声明，则修改相应语句，仅提供一个 GLOBAL 声明即可解决问题。