ORA-14302: only one list of added-LOB-storage-clauses can be specified in a statement ORACLE 报错 故障修复

文档解释

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存储。