Downsize of a Column Cannot Be Done even the Change was not Promoted to Production Lifecycle (Doc ID 2851159.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

On Oracle Life Sciences Data Management Workbench (DMW) 3.1.0 version,

ACTUAL BEHAVIOR
---------------
For a Data Model in Production lifecycle, users can't do a downsize of a column even if the model with the change is not promoted to Production.


EXPECTED BEHAVIOR
-----------------------
It would be expected that the system should allow to revert back the changes from Development lifecycle.


STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Create a Data Model A with a Table T1 and column C1 with VARCHAR2(2000).
2. Install Data Model A.
3. Promote to Production lifecycle and Install.
    You will have Data Model A with Table T1 and column C1 VARCHAR2(2000) in Production lifecycle.
4. Check out Data Model A in Development lifecycle.
5. Edit the column C1 from table T1 and change it to VARCHAR2(3000) and save it.
6. Edit the column C1 to 2000 and save it.
    Error: "DMW-###: Destructive changes to a column are not supported after the data model has been upgraded to Production: Decrease in VARCHAR2 length."

Cause

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