Forum Stats

  • 3,780,909 Users
  • 2,254,454 Discussions
  • 7,879,490 Comments

Discussions

Generate DDL: Default Physical Model

mmagan-Oracle
mmagan-Oracle Member Posts: 30 Employee

File > Export DDL File brings up the dialogue which (in my case) defaults to Oracle Database 12c. I want to change the default to Oracle Database 12cR2. How do I do that?

After changing the option to "Oracle Database 12cR2", it defaults back to "Oracle Database 12c" the next time I run the DDL generator.

One may expect that the default is taken from here:

pastedImage_0.png

That appears not to be the case.

:

Best Answer

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

    The setting in preferences is for initial value when new model is created. After that setting at relational model takes precedence.

    How DM calculates the model:

    - current diagram;

    - if there is no visible diagram, the the selection in the browser - if selection is on specific physical model then that model is the selected one.

    Philip

Answers

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

    The setting in preferences is for initial value when new model is created. After that setting at relational model takes precedence.

    How DM calculates the model:

    - current diagram;

    - if there is no visible diagram, the the selection in the browser - if selection is on specific physical model then that model is the selected one.

    Philip