My Oracle Support Banner

Unexpected Number Data Type Precision Change By "unpivot" Operator (Doc ID 2516770.1)

Last updated on OCTOBER 07, 2021

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 18 to 19]
Information in this document applies to any platform.


The datatype and the precision is changed during unpivot.  The test case is clearly explains the issue. 
Till, there was not change observed in the Datatype using unpivot. But from onward, the issue starts. 
The test case is done provided on and versions.
The Datatype should not be changed when using the UNPIVOT.  This causes the failure on the exchange partition operations. 

This cause the below error in exchange partition options. 

ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION


No changes


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.