The following is the ORA-22858 error message, you can learn the cause and solution of the Oracle database error.


ORA-22858 invalid alteration of datatype

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

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

Case:

Please wait for the update…