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 184.108.40.206.0 to 220.127.116.11.0 [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 18.104.22.168, there was not change observed in the Datatype using unpivot. But from 22.214.171.124 onward, the issue starts.
The test case is done provided on 126.96.36.199 and 188.8.131.52 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