ORA-14061: During Converting DB With DMU (Doc ID 2069935.1)

Last updated on DECEMBER 05, 2016

Applies to:

Database Migration Assistant for Unicode - Version 2.0 and later
Information in this document applies to any platform.

Symptoms

In the last phase of DMU conversion following error is seen:

 "Finished with error
 14061 _ ORA-14061: data type or length of an index partitioning column may not be changed" by doing

 "alter table "Test"."source" modify("col1" vachar2(120 BYTE))"

 

Changes

 examining  the DDL for problematic Table reported by the error we could see that "col1" column is involved in  compressed indexes:

 

 



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