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 18.3.0.0.0 to 19.1.0.0.0 [Release 18 to 19]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 |