Faulty Upgrade Tool Script Causes Error: "ORA-22858: invalid alteration of datatype" (Doc ID 2352691.1)

Last updated on SEPTEMBER 03, 2020

Applies to:

Symptoms

The SQL-script (ora/sql/db_defaults.sql) found in the e6.2.0 upgrade tool has a defective SQL command.  The ORA-22858: invalid alteration of datatype indicates that a space character is missing in the SQL script.



ERROR

Table altered.

SQL> ALTER TABLE T_ASR_PLF_DAT MODIFY(LEV_IND DEFAULT110 );
ALTER TABLE T_ASR_PLF_DAT MODIFY(LEV_IND DEFAULT110    )
                                *
ERROR at line 1:
ORA-22858: invalid alteration of datatype

==========================

ALTER TABLE T_CPS_ELM_DAT MODIFY(LEV_IND DEFAULT110 );
ALTER TABLE T_CPS_ELM_DAT MODIFY(LEV_IND DEFAULT110    )
                                *
ERROR at line 1:
ORA-22858: invalid alteration of datatype

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.