Unable to increase Precision fails with ORA-20205
(Doc ID 2639993.1)
Last updated on APRIL 17, 2023
Applies to:Workspace Manager - Version 220.127.116.11 to 18.104.22.168.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