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

SQL*Loader-00417: SQL string (on column string) not allowed in direct path.

1 Answers  


SQL*Loader-00102: Invalid control file name on command line

1 Answers  


ORA-16138: end of log stream not received from primary

1 Answers  


ORA-12802: parallel query server lost contact with coordinator

1 Answers  


RMAN-06474: maintenance channels are not allocated

1 Answers  






ORA-23502: valid directory for offline instatiation is not specified

1 Answers  


PLS-01405: Under ANSI's grammar, numeric data represented in exponent notationmust use an uppercase E

1 Answers  


ORA-38733: Physical size string less than needed string.

1 Answers  


NNL-01001: NAME EXISTS responses received: number

1 Answers  


NNL-00851: Renames refused, name is not a leaf name: number

1 Answers  


ORA-02004: security violation

1 Answers  


ORA-09859: sfngat: the input file name is not in the autobackup OMF format

1 Answers  


Categories