UTF8 Migration pack fails while trying to create an Index on the target database
search cancel

UTF8 Migration pack fails while trying to create an Index on the target database

book

Article ID: 398559

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine Automic SaaS CA Automic One Automation

Issue/Introduction

UTF8 Migration Action Pack fails with the below error upon trying to create an Index on the target database

create   index NK_OT_SEARCH_NC on OT (OT_OH_IDNR ASC,OT_TYPE ASC,OT_LNR ASC,SUBSTR(UPPER("SYS"."DBMS_LOB"."SUBSTR"("OT_CONTENT",2000,1)),1,2000) ASC) tablespace UC4_INDEX
ORA-01450: maximum key length (6397) exceeded

Environment

Database: Oracle (UTF8)

Cause

Incorrect configuration of max_string_size on the destination database

Resolution

To resolve this issue, ensure that the max_string_size parameter on the target UTF-8 database is set correctly:

  • Recreate the target database with max_string_size set to Standard.

  • If max_string_size must be set to Extended, then ensure that the tablespace block size is configured to 32K to support the extended string sizes.

Note: This is automatically checked by the Upgrade checker in UTF8 DB MIGRATION PACK 1.0.8 and above.

Powered by Wolken Software