Faulty Upgrade Tool Script Causes Error: "ORA-22858: invalid alteration of datatype"
(Doc ID 2352691.1)
Last updated on SEPTEMBER 03, 2020
Applies to:
Oracle Agile Engineering Data Management - Version 6.1.3.0 and laterInformation 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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |