Unable to increase Precision fails with ORA-20205
(Doc ID 2639993.1)
Last updated on APRIL 24, 2020
Applies to:Workspace Manager - Version 22.214.171.124 to 126.96.36.199.0 [Release 12.1 to 18]
Information in this document applies to any platform.
Unable to increase some of the fields of a version enabled table from a number(8,3) to a number(9,4) :
ALTER TABLE <TABLE_NAME> modify (COLUMN1 NUMBER(9,4));
Error starting at line : 14 in command -
BEGIN DBMS_WM.CommitDDL('<NAME>'); END;
Error report -
ORA-20205: COLUMN1 contains data - cannot be modified
ORA-06512: at "WMSYS.LT", line 2868
ORA-06512: at line 1
As per documentation this should be possible.
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