My Oracle Support Banner

Database Diff is not Recognizing Objects in Both Source and Destination Connection (Doc ID 2321138.1)

Last updated on MARCH 03, 2025

Applies to:

Oracle SQL Developer - Version 17.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms


When comparing views in a schema from one database against the same schema in another database using the Database Diff feature, it seems to only analyze one of the 2 databases. The tool seems to not recognize objects in the second database. It was tried using the same 2 environments both as A vs B and as B vs A. It always shows results for whichever environment one lists first and seems to think no objects exist in the second environment.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.