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 22.214.171.124.0 to 126.96.36.199.0 [Release 18]
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 188.8.131.52, there was not change observed in the Datatype using unpivot. But from 184.108.40.206 onward, the issue starts.
The test case is done provided on 220.127.116.11 and 18.104.22.168 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
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