ORA-14126: only a may follow description(s) of resulting partitions

文档解释

ORA-14126: only a may follow description(s) of resulting partitions

Cause: Descriptions of partition(s) resulting from splitting of a table or index partition may be followed by an optional which applies to the entire statement and which, in turn, may not be followed by any other clause.

Action: Ensure that all partition attributes appear within the parenthesized list of descriptions of resulting partitions in ALTER TABLE/INDEX SPLIT PARTITION statement.

ORA-14126: only a may follow description(s) of resulting partitions 是由于使用了并行操作符(如PARALLEL)而没有定义操作符时报出的错误。

官方解释

尝试对对象使用并行操作符,但只定义了分区,没有定义其他操作符时,将抛出ORA-14126错误。

常见案例

正常处理方法及步骤

“`sql

UPDATE USERS

SET USER_NAME = ‘Admin’

PARALLEL ( UPDATE USERS

SET USER_NAME = ‘AdminUser’

WITHIN RECORD

);

“`

上面的SQL语句正确地使用了并行操作符,以及必要的更新语句,因此不会引发ORA-14126错误。

你可能感兴趣的