ORA-14302: only one list of added-LOB-storage-clauses can be specified in a statement

文档解释

ORA-14302: only one list of added-LOB-storage-clauses can be specified in a statement

Cause: While parsing an ALTER TABLE ADD COLUMN statement, one list of added-LOB-storage-clauses was parsed when another list of added-LOB-storage-clauses was encountered. There cannot be more than one list of added-LOB-storage-clauses in a statement; all added-LOB-storage-clauses must be combined into one list.

Action: Combine all of the lists of added-LOB-storage-clauses into one list and retry the statement.

ORA-14302:只能在语句中指定一个添加的LOB存储子句列表。

官方解释

常见案例

正常处理方法及步骤

1)检查语句中是否指定了多个LOB存储子句列表,

2)检查根据官方文档要求,查找是否有未知LOB参数,

3)分别执行ALTER TABLE命令添加每个LOB存储,

4)正确执行ALTER TABLE命令更改LOB存储。

你可能感兴趣的