Siebel 8.1.1.11 IRM Fails With Error ORA-01439: Column To Be Modified Must Be... (Doc ID 1619626.1)

Last updated on JULY 20, 2016

Applies to:

Siebel CRM - Version 8.1.1.11 SIA [23030] and later
Information in this document applies to any platform.

Symptoms

Problem Statement :
--------------------------
Error ORA-01439 column to be modified must be empty to change datatype While performing IRM on table S_SRV_REQ_X for column ATTRIB_14

Error :
--------
ORA-01439: column to be modified must be empty to change datatype

Versions :
-----------
Siebel CRM 8.1.1.11 SIA [23030]
HP-UX Itanium 11.31
Oracle Database 11.2.0.1- Enterprise Edition
HP-UX Itanium 11.31

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