My Oracle Support Banner

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

Last updated on FEBRUARY 23, 2022

Applies to:

Oracle Health Sciences Data Management Workbench - Version 3.1.0 and later
Information in this document applies to any platform.


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

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.

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

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."


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

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