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!

MView delta deploy problem between SDDM and db schema (Swap target model Dictionary import - DDL Pre

xkbFeb 10 2016 — edited Mar 29 2016

Hi,

I'm having a hard time to reverse merge the difference between my model and my database schema.

The initial goal is simple :

1/ detect metadata differences

2/ have SDDM generate DDL alter code

(if possible, otherwise, recreate, reload : powerful existing feature BTW)

3/ deploy

4/ check/confirm that no more delta existing

I'm doing that by :

* menu File > Import > Dictionary

* select Connection

* select db schema

* check "Swap Target Model"

* select MY_MVIEW > Next (1 TABLE DB Object to be imported) > Finish ("Generate Design" working)

* in Compare Models window I deselect all, minus MY_MVIEW table AND also MY_VIEW Materialized View

(as they appear as 2 objects in SDDM)

* button DDL Preview

I see :

- comments created first (whereas the MVIEW is to be recreated)

that is of less importance but still blurs the readability

- MY_MVIEW is systematically recreated

(how many times ever I deploy)

I figured out :

. both SDDM objects table (relational, implemented as MVIEW) and MVIEW (physical) host the query independantly

. even if I sync them manually (copy-paste), DDL code deployed is not strictly the same as

So may it have to do with a compare dysfunction ?

SDDM is full of options do desensitize compare (exclude physical, storage, etc.) but I haven't found my way to simply compare and align MVIEWs

(and documentation is scarce on the topic)

Any hint ?

Thx

This post has been answered by David Last-Oracle on Feb 24 2016
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 26 2016
Added on Feb 10 2016
11 comments
1,931 views