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 and later
Information in this document applies to any platform.


  uname => 'SCHEMA1',
  tname => 'DR$XMLBLOB_INDEX$I',
  lob_store_as => 'SECUREFILE');

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


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