Unable to increase Precision fails with ORA-20205
(Doc ID 2639993.1)
Last updated on APRIL 17, 2023
Applies to:
Workspace Manager - Version 12.1.0.2 to 18.5.0.0.0 [Release 12.1 to 18]Information in this document applies to any platform.
Symptoms
Unable to increase some of the fields of a version enabled table from a number(8,3) to a number(9,4) :
EXECUTE DBMS_WM.BeginDDL('<NAME>');
ALTER TABLE <TABLE_NAME> modify (COLUMN1 NUMBER(9,4));
EXECUTE DBMS_WM.CommitDDL('<NAME>');
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.
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 |
| Cause |
| Solution |
| References |