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!

SQLDev diff report - identical tables reported as different

flaviocMay 13 2020 — edited May 16 2020

Hi,

did anyone encounter this problem?

I was checking two tables located on two instances, same db version, same definition, but SQLDev diff report run with the default options (ignore tablespace, storage, match constraints by definition, etc.) marks them with the yellow exclamation mark however the scripts generated for both are identical (copied and pasted into a file merge utility just in case I am blind and they are 100% equal).

This happens with either SQLDev 19.2.1 or 19.4, db version is 12.2.0.1 EE

Any ideas?
Is this a known problem?

Thank you

Flavio

Comments
Post Details
Added on May 13 2020
12 comments
452 views