My Oracle Support Banner

How To Enlarge A Column With A Text Index On It? (Doc ID 359154.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Text - Version 11.2.0.4 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.
Information in this document applies to any platform.

Goal

Attempting to resize a column with a Text index on it fails with below error:

SQL> alter table test modify text varchar2(132);
alter table test modify text varchar2(132)
*
ERROR at line 1:
ORA-29885: domain index is defined on the column to be modified

How can I achieve this other than dropping the Text index, resizing the column and recreating the Text index?

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
References


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