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

NZE-28755: object retrieval failure

1 Answers  


ORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.

1 Answers  


ORA-00437: ORACLE feature is not licensed. Contact Oracle Corp. for assistance

1 Answers  


ORA-32637: Self cyclic rule in sequential order MODEL

1 Answers  


PCB-00627: Host variable is not of character type

1 Answers  






PLS-01406: An identifier has been found that is considered a keyword in ANSI's grammar but not in PL/SQL's

1 Answers  


ORA-15132: block string of file string in diskgroup string could not be written

1 Answers  


IMP-00004: invalid username or password

1 Answers  


ORA-40212: invalid target data type in input data for string function

1 Answers  


QSM-00765: cannot validate user-defined workload because table string.string is invalid.

1 Answers  


ORA-30695: JDWP message format problem

1 Answers  


NID-00312: Connected to server version string

1 Answers  


Categories