My Oracle Support Banner

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

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
Symptoms
Cause
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.