My Oracle Support Banner

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

Last updated on OCTOBER 01, 2013

Applies to:

Oracle Text - Version 9.2.0.1 to 12.1.0.1 [Release 9.2 to 12.1]
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!


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