ORA-22858: invalid alteration of datatype



ORA-22858: invalid alteration of datatype..

Answer / guest

Cause: An attempt was made to modify the column type to
object, REF, nested table, VARRAY or LOB type.

Action: Create a new column of the desired type and copy the
current column data to the new type using the appropriate
type constructor.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16766: Physical apply service unexpectedly offline

1 Answers  


NZE-29046: Session is resumable.

1 Answers  


ORA-01329: unable to truncate require build table

1 Answers  


ORA-06120: NETTCP: network driver not loaded

1 Answers  


DRG-10517: index string is already valid

1 Answers  






ORA-06114: NETTCP: SID lookup failure

1 Answers  


ORA-12425: cannot apply policies or set authorizations for system schemas

1 Answers  


ORA-19608: %s is not a backup piece

1 Answers  


ORA-27415: repeat interval must start with the FREQ= clause

1 Answers  


TNS-01168: Cannot allocate memory

1 Answers  


NNO-00160: warning: ignoring duplicate hint server "string"

1 Answers  


ORA-38488: attribute set already assigned to the column storing expressions

1 Answers  


Categories