Can ORA-01439: column to be modified must be empty to change datatype Errors on the _T Tables Be Ignored When Running Upgrade_bsp_schema_61_80.sh? (Doc ID 2136978.1)

Last updated on MAY 11, 2016

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Balance Sheet Planning (BSP)

Goal

The following error messages are thrown while trying to upgrade the BSP 6.1 schema to BSP 8.0 using the supplied shell scripts "upgrade_bsp_schema_61_80.sh".

ALTER TABLE FSI_BSP_MATURITY_MIX_T MODIFY ("ORG_UNIT_ID" VARCHAR2(60 CHAR))
*
ERROR at line 1:
ORA-01439: column to be modified must be empty to change datatype


ALTER TABLE FSI_BSP_MATURITY_MIX_T MODIFY ("STRATEGY_ID" VARCHAR2(60 CHAR))
*
ERROR at line 1:
ORA-01439: column to be modified must be empty to change datatype

Confirmed that the table mentioned is not empty.

Solution

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