Faulty Upgrade Tool Script Causes Error: "ORA-22858: invalid alteration of datatype"

(Doc ID 2352691.1)

Last updated on JANUARY 25, 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

	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 hundreds of Community platforms