Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Database Diff cluttered with sequence details

Soeren DFeb 13 2024 — edited Feb 13 2024

I would like to compare two databases and eventually upgrade the destination database with the script generated.

It appears as if my sequences gets different names on each database and thus the diff report is cluttered with sequences information that are useless to me.

I have tried to exclude sequences:

But that wasn't enough. I have two questions:

  1. Does SQL Developer have a feature that excludes sequences from the compare?
  2. If I choose to transfer sequence changes from source to the destination so they are no longer different - will that have some impact such as next number in sequence on destination database ? Or is it only naming and thus has no effect otherwise?

Thanks in advance

Kind regards
Soeren D.

Comments
Post Details
Added on Feb 13 2024
5 comments
85 views