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:

Symptoms

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

Changes

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

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.