My Oracle Support Banner

23.1 - Oracle SDDM - Missing Synonyms with Import and Merge from the Data Dictionary (Doc ID 2987340.1)

Last updated on NOVEMBER 22, 2023

Applies to:

Oracle SQL Developer Data Modeler - Version 23.1 and later
Information in this document applies to any platform.


SQL Developer Data Modeler (SDDM) 23.1 is installed.
When trying to Import data dictionary to the existing model with newly created Synonyms is missing, on completion of merge with the Physical Datamodel.

File-->Import-->Data Dictionary

Select objects, synonym to merge with Physical model


Note: The examples used below is only for educational purpose and to demostrate the issue. Any represenatiaon of actual data should be omitted.

1. Use an existing data model

2. Create new synonym in the target schema using sqlplus/SQL Developer.

Example: CREATE OR REPLACE SYNONYM hr.dpt_syn_pvt1 FOR hr.departments;

3. Use File-->Import-->Data Dictionary

4. Connect to the target database where new synonym created

5. Select Schema/Database

6. Under "Select Objects to Import" -->Select the new synonym "dpt_syn_pvt1/DEPARTMENTS"

7. Click Finish

8. Under Compare Models-->Click DDL Preview and Merge.

9. Verify under Physical Model-->Synonyms. Check the new synonym dpt_syn_pvt1 is missing to merge with the existing model





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.