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!

Deferred constraint changes are not seen in the 'synchronize data dictionary' DDL

AndyHDec 2 2025

SDDM 24.3

I have made some existing unique constraints deferrable in the Physical Model.

When I create DDL for the relevant tables, the constraints are shown as deferrable.

If I run ‘sychronize data dictionary', the constraints do not appear in the generated DDL. The comparison includes physical details, and the differences are highlighted in the ‘Physical Details’ section of ‘Compare Models’.

Is this a bug or am I missing a setting?

Comments
Post Details
Added on Dec 2 2025
0 comments
57 views