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 enhancement proposal: Compare objects with system generated names on contents

Peter de VaalJul 25 2017 — edited Jul 26 2017

The Database Diff tool in SQLDev is very helpful in finding differences between schemas (e.g. between Dev and Test). It has the option to compare constraints only on their definition and ignore name differences. This is very helpful when having in-line constraint definitions without a name, because these get a system generated name which differs in each schema.

However, system generated names are not only limited to constraints. Just 2 other examples are the sequence name of Identity columns and the names of IOT Overflow tables.

Currently these always appear as differences on a Database Diff run.

It would be nice to have the option to compare all such objects on definition and not on name.

This post has been answered by unknown-7404 on Jul 25 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2017
Added on Jul 25 2017
3 comments
203 views