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 table level check constraint

mmagan-OracleJul 11 2021 — edited Jul 14 2021

I have defined a table level constraint:
date_id = trunc(date_id)

When I run "Synchronize Data Dictionary with Model", the following DDL is consistently generated:

ALTER TABLE pm_data_mart.dmt_date_dimension DROP CONSTRAINT dmt_date_dimension_ck_1;
ALTER TABLE pm_data_mart.dmt_date_dimension
ADD CONSTRAINT dmt_date_dimension_ck_1 CHECK ( date_id = trunc(date_id) );

If I run the two statements and then repeat "Synchronize Data Dictionary with Model", I would expect no DDL but the same two statements are generated again.
Why is this happening and how can it be prevented?
PS: Version 21.1.0.092 Running against Oracle 19c database.

Comments

Jonathan Hult
1 - 1

Post Details

Added on Jul 11 2021
2 comments
71 views