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-33050: (XSAGDNGL24) AGGMAP workspace object cannot be used to aggregate workspace object, because it is defined in a different analytic workspace.

1 Answers  


ORA-12011: execution of string jobs failed

1 Answers  


DRG-12412: missing or invalid Template Processor attribute (string)

1 Answers  


SQL-02104: Inconsistent host cache. No cursor cache available

1 Answers  


ORA-07880: sdopnf: internal error

1 Answers  






RMAN-06494: %s = string is out of range (string-string)

1 Answers  


ORA-14325: only LOCAL indexes may be specified in this clause

1 Answers  


ORA-24096: invalid message state specified

1 Answers  


ORA-07760: slemtr: $open failure

1 Answers  


ORA-16719: unable to query V$ARCHIVE_DEST fixed view

1 Answers  


ORA-23495: serial propagation can not be used for "string"

1 Answers  


ORA-30556: functional index is defined on the column to be modified

1 Answers  


Categories