My Oracle Support Banner

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

Last updated on JUNE 21, 2018

Applies to:

Oracle Agile Engineering Data Management - Version 6.1.3.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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