Oracle Error ORA-22296: invalid ALTER TABLE option for conversion of LONG datatype to LOB

Oracle Error Message

ORA-22296: invalid ALTER TABLE option for conversion of LONG datatype to LOB

Reason for the Error

An attempt was made to specify ALTER TABLE options which are disallowed during conversion of LONG datatype to LOB. The only ALTER TABLE options allowed during conversion of LONG datatype to LOB are the default clause and LOB storage clause for the column being converted to LOB.

Solution

Remove the disallowed options.