My Oracle Support Banner

Unable to increase Precision fails with ORA-20205 (Doc ID 2639993.1)

Last updated on APRIL 24, 2020

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.