Forum Stats

  • 3,780,928 Users
  • 2,254,456 Discussions
  • 7,879,497 Comments

Discussions

Synchronize with Data Dictionary: questions

mmagan-Oracle
mmagan-Oracle Member Posts: 30 Employee

I defined and generated a table like this:

CREATE TABLE dms_projects (

    id                 NUMBER(18)

        GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 NOCACHE ORDER )

    NOT NULL,

    created_by         VARCHAR2(254 CHAR) NOT NULL,

    creation_date      DATE NOT NULL,

    last_updated_by    VARCHAR2(254 CHAR) NOT NULL,

    last_updated_date  DATE NOT NULL

)

LOGGING;

ALTER TABLE dms_projects ADD CONSTRAINT dms_projects_pk PRIMARY KEY ( id );

After running this script, I want to compare (and expecting no differences)

Tools > preferences > Data modeler > DDL > DDL Comparison and deselect all options

Then right-click on the table, select Synchronize with Data Dictionary and press OK.

I see a difference at the table level:

pastedImage_0.png

It also shows a difference on the ID column as shown below:

Annotation 2020-06-27 105804.png

The DDL preview does not contain anything (that's good), but I find the indications distracting when performing the synchronization.

How do I prevent/fix this?

Best Answer

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,367 Employee
    edited Jul 6, 2020 2:59AM Accepted Answer

    In the same dialog - if you expand "Options" sub-tree then you'll find different options that affect comparison and DDL generation.

    Starting from the model you need to exclude storage and physical properties from comparison. There are filters you can use to exclude from comparison some properties at object type level .

    Philip

Answers

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,367 Employee
    edited Jul 6, 2020 2:59AM Accepted Answer

    In the same dialog - if you expand "Options" sub-tree then you'll find different options that affect comparison and DDL generation.

    Starting from the model you need to exclude storage and physical properties from comparison. There are filters you can use to exclude from comparison some properties at object type level .

    Philip