My Oracle Support Banner

SQL Developer Database Diff Comparing Two Schemas With No Password As Privileged User (Doc ID 2764719.1)

Last updated on MARCH 30, 2021

Applies to:

Oracle SQL Developer - Version 19.4 and later
Information in this document applies to any platform.

Goal

Using Database Diff feature in SQL Developer, you want to perform a DDL comparison between two database schemas; however, you do not know the password for the object owner in either database. You can log into the database with a privileged user such as SYSTEM or SYS, but when try to run the comparison tool as SYSTEM, it always says that every single object from the source schema in the first database does not exist in the SYSTEM schema in the destination.

Is there any way to effectively run the Database Diff tool in SQL Developer for a schema that is not the one logged into (that is, as a privileged used such as SYSTEM)?
 

Solution

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
Goal
Solution
References


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