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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing

Post Details

Added on Jul 11 2021
2 comments
95 views