ORA-14003: GLOBAL clause contradicts previosly specified LOCAL clause
Cause: CREATE INDEX statement contained a LOCAL clause and a GLOBAL clause
Action: Specify GLOBAL or LOCAL clause, but not both
等
ORA-14003: GLOBAL clause contradicts previosly specified LOCAL clause 错误表明被解析器发现你在一个语句中先声明了一个LOCAL存储段,然后在后面加了一个GLOBAL存储段,二者 是不允许一起使用的,需要分别声明。
来自官方文档:
ORA-14003: GLOBAL clause contradicts previosly specified LOCAL clause
Cause: You attempted to define a segment using BOTH “LOCAL” and “GLOBAL” keywords within the same SQL statement.
Action: Splitting the local and global definitions into separate SQL statements will resolve this issue. LOCAL and GLOBAL keywords could not be used together within the same SQL statement.