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

ORA-06131: NETTCP: user access denied

1 Answers  


ORA-06744: TLI Driver: listener cannot bind

1 Answers  


TNS-01113: save_config_on_stop can either be ON or OFF

1 Answers  


ORA-27476: "string.string" does not exist

1 Answers  


ORA-21520: database server driver not installed

1 Answers  






ORA-12806: could not get background process to hold enqueue

1 Answers  


ORA-01355: logminer tablespace change in progress

1 Answers  


TNS-12213: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  


DRG-50947: ABOUT clause not allowed without a theme index

1 Answers  


ORA-00254: error in archive control string 'string'

1 Answers  


PLS-00728: the limit of a VARRAY can only be increased and to a maximum 2147483647

1 Answers  


ORA-03001: unimplemented feature

1 Answers  


Categories