IRM Failing For 8.1.1.11 with error ORA-01439: column to be modified must be empty to change datatype (Doc ID 1627303.1)

Last updated on MARCH 07, 2014

Applies to:

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

Symptoms

On : 8.1.1.11 SIA [23030] version, Universal Customer Master

IRM failing for 8.1.1.11

We have applied 8.1.1.11 as patch on 8.1.1.7 on development environment.
We are following ' Siebel Database upgrade guide (Siebel Innovation Pack 2013) chapter 13 to run IRM .
IRM (upgrep ) is failing at 'ddlimp' step with the folloiwng error
================================================
alter table S_ORG_EXT_X modify
"ATTRIB_10" char(1 char)
2014-01-24 11:59:59 [DataDirect][ODBC 20101 driver][20101]ORA-01439: column to be modified must be empty to change datatype

2014-01-24 11:59:59
2014-01-24 11:59:59 60: [DataDirect][ODBC 20101 driver][20101]ORA-01439: column to be modified must be empty to change datatype
2014-01-24 11:59:59
2014-01-24 11:59:59 alter table S_ORG_EXT_X modify
2014-01-24 11:59:59 "ATTRIB_10" char(1 char)
==============================
As ATTRIB_10 column holds data and ddlimp trying to change datatype, hence it is failing.


 

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




 

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