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

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

Oracle Error Message

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

Reason for the Error

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.

Solution

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

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...