My Oracle Support Banner

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

Last updated on JULY 03, 2019

Applies to:

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

Symptoms

The datatype and the precision is changed during unpivot.  The test case is clearly explains the issue. 
Till 12.1.0.2, there was not change observed in the Datatype using unpivot. But from 12.2.0.2 onward, the issue starts. 
The test case is done provided on 11.2.0.4 and 18.0.0.0 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

Changes

No changes

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.