My Oracle Support Banner

ORA-43923/ ORA-54022 Reporting while altering the virtual column when an index is defined on the column (Doc ID 2628379.1)

Last updated on JANUARY 15, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

ORA-43923: The column cannot be modified to the specified collation.

Problem Description
---------------------------------------------------
Given a table with the virtual column which references other columns of type varchar2

F_4015782080 VARCHAR2(4000) GENERATED ALWAYS AS (trim(NVL(F_4015782334, '') || ' ' || NVL(F_4015782332, '') || ' ' || NVL(F_4015782722, ''))) VIRTUAL

When an index is placed on this column, modifying this column produces the error

ORA-43923: The column cannot be modified to the specified collation.

If index is removed then column can be modified.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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