Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Synchronize Domain constraints

mmagan-OracleJul 11 2021 — edited Jul 14 2021

I have a domain defined with a check constraint, defined as a Generic Constraint:
%COLUMN% = upper(%COLUMN%)
I have a table with two columns based on this domain.
When I run "Synchronize Data Dictionary with Model", the following DDL is consistently generated:
ALTER TABLE pm_data_mart.stg_worklogs DROP CONSTRAINT stg_worklogs_ck_parentkey;
ALTER TABLE pm_data_mart.stg_worklogs
ADD CONSTRAINT stg_worklogs_ck_parentkey CHECK ( parentkey = upper(parentkey) );
I.e. one of the two constraints is recreated. Is this a bug?
(Version 21.1.0.092 running against 19c database)

Comments

Post Details

Added on Jul 11 2021
2 comments
97 views