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

The following is the cause of this 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.

Action you can take to resolve this issue: Remove the disallowed options.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related