文档解释
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错误。