My Oracle Support Banner

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 MARCH 09, 2023

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

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.