Monday 9 April 2012

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

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

Cause: 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: Remove the disallowed options.

No comments:

Post a Comment