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!

Sqldeveloper 20.4 database diff function strange result

Dezsoe KadosFeb 5 2021

When comparing two schemas I get the following result in some cases:
-----------------------------------------------------------------
schema.package using connection_name connection.
Unable to compare objects.
Ensure that you have the required permissions.
You must own the objects or have select_catalog_role.
-----------------------------------------------------------------

Makes no sense as both connections own the respective package.
I have seen this happening already from (at least) sqtdeveloper 19.x on

Source DB info:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Target DB info:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Sqldeveloper info
About
-----

Oracle SQL Developer 20.4.0.379
Version 20.4.0.379
Build 379.2205

IDE Version: 12.2.1.5.42.201006.2103
Product ID: oracle.sqldeveloper
Product Version: 20.4.0.379.2205

Version
-------

Component Version
========= =======
Oracle IDE 20.4.0.379.2205
Java(TM) Platform 1.8.0_271

Properties
----------

Name Value
==== =====

Extensions
----------

Name Identifier Version Status Registration Time Initialization Time Total Time
==== ========== ======= ====== ================= =================== ==========

Comments

Post Details

Added on Feb 5 2021
15 comments
838 views