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!

Understanding Data Dictionary Synchronization

apexframeworkerOct 22 2014

Hi,

1. Adding one or more columns of a table in the model

2. Choose the right blue button to synchronize the data dictionary:

  • the "Choosing data dictionary" dialog appears
  • the "Compare Model" dialog appears

Maybe I don't understand what "synchronize the data dictionary" exactly means. I my opinion the change made under 1. has to be translated into 'alter table' DDL command's

but the modeler creates only 'create table' command's.

Furthermore I don't understand the hint of the buttons below from the perspective of synchronization:

  • "Synchronize new objects" - If i cklick on it, always the successfull message appears, but nothing else happens
  • "Consolidate" - hmm, is greyed out - if make changes via SQLPlus in one of the tables and choose the left blue button "Synchronize model with data dictionary", my model won't be consolidated
  • "DDL Preview" - as I described above, always 'create' statements will be generated. If the tables were already created and maybe filled, this makes no sense.

I'm working with version 4.0.0.13.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2014
Added on Oct 22 2014
0 comments
624 views