Skip to Main Content

SQL Developer

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!

Database Diff Foreign keys order

BeGinNov 14 2017 — edited Nov 17 2017

Hello,

We use SQLDeveloper 17.2.

We use Database difference to manage structure upgrades between dev and prod.

When developers create a lot of new tables with foreign keys, we have a big issue with this process : as tables seem to be created in alphabetical order, they always have some FK referencing PK on new tables not yet created.

Is there a way to ask database diff to create all fk constraints in the end of the script ? Or another way to manage this ? We perhaps don't use the right tool .

Thanks for the help.

Regards,

--

Bertrand

This post has been answered by thatJeffSmith-Oracle on Nov 16 2017
Jump to Answer

Comments

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

Post Details

Locked on Dec 15 2017
Added on Nov 14 2017
10 comments
282 views