This discussion is archived
6 Replies Latest reply: Jan 15, 2013 7:22 AM by Tony Rose RSS

Synchronize Model with Data Dictionary shows virtual diffs for all VARCHAR2

scw2wi Newbie
Currently Being Moderated
I have imported my model from Designer and Data Dictionary
with the flag "Use Schema Property" deselected
(otherwise the tables and entities would not be joined)

Logical, Relational and Physical Models are looking fine.

When I start Synchronize Model with Data Dictionary
all tables are marked to have differences.
But when I check the diffs, they are just virtual, like:

Data Type:      VARCHAR2 (2000 BYTE )     <=> VARCHAR2 (2000)
Data Type Kind:     Logical Type(VARCHAR)     <=> Domain (MEMO)
LOV Constraint:     'Y','N'               <=> Y,N

The canvas "Data type conversion" is listing all these columns,
but here I can select "Recreate Table" only, which does not solve the problem.

How can I avoid such virtual differences?

my SDDM Version is


  • Correct Answers - 10 points
  • Helpful Answers - 5 points