How To Upgrade Tables With Context Indexes To User Securefile

(Doc ID 2336462.1)

Last updated on DECEMBER 19, 2017

Applies to:

Oracle Text - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

DBMS_REDEFINITION.REDEF_TABLE(
  uname => 'SCHEMA1',
  tname => 'DR$XMLBLOB_INDEX$I',
  lob_store_as => 'SECUREFILE');
  END;

ORA-42012: error occurred while completing the redefinition
ORA-29962: fatal error occurred in the execution of ODCIINDEXALTER routine
ORA-29960: line 1, Oracle Text error:
DRG-11439: index name length exceeds maximum of 25 bytes
ORA-06512: at "SYS.DBMS_REDEFINITION", line 3385
ORA-06512: at line 2

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