My Oracle Support Banner

ORA-14097 DURING EXCHANGE PARTITION WITH MAX_STRING_SIZE = EXTENDED (Doc ID 3074782.1)

Last updated on MARCH 11, 2025

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

With MAX_STRING_SIZE set as  EXTENDED partition exchange hits error ORA-14097

Trying to exchange a table with a formerly "old" varchar column that was extended to a size > 4000 bytes with a newly created table with an initial length of > 4000 bytes will fail.

Changes

 Issue is noticed after MAX_STRING_SIZE is modified from the default value of STANDARD to EXTENDED 

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
Changes
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.