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..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

LRM-00122: value 'string' for 'string' must be between 'number' and 'number'

1 Answers  


ORA-13368: simple polygon type has more than one exterior ring

1 Answers  


ORA-15073: diskgroup string is mounted by another ASM instance

1 Answers  


NNL-00280: No restart currently scheduled

1 Answers  


NNL-00870: Update requests received: number

1 Answers  






ORA-30352: inconsistent numeric precision or string length

1 Answers  


TNS-00219: Pump Strategy : string

1 Answers  


PLS-00396: INSERT statement's subquery yields wrong number of columns

1 Answers  


ORA-02262: ORA-string occurs while type-checking column default value expression

1 Answers  


ORA-16199: Terminal recovery failed to recover to a consistent point

1 Answers  


TNS-00204: Started tracing in intlsnr

1 Answers  


PCC-02344: Host variable array size mismatch. Using minimum: number

1 Answers  


Categories