Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Sqldeveloper 20.4 database diff function strange result

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
==== ========== ======= ====== ================= =================== ==========
Answers
-
Have a very similar situation, with similar source and target DB versions. Were you able to resolve this issue?
-
No, I could not resolve the issue (20.4.1.407 does not solve it either so far I can tell)
-
Thanks for the quick update Dezsoe. I have other tools I can use for this comparison, but was trying to make use of tools provided by the client I am supporting.
-
can you reproduce this issue if you say...
create user abc121 ...
connect abc123/...
create or replace package do_nothing....
/
then
create user abc19c ...
connect abc19c/...
create or replace package do_nothing....
/
open Compare wizard, with a connection created for both abc123 and abc19c, compare packages - does the error come up?
In other words, I need a test case.
Jeff
-
Jeff, have not done extensive testing, just hit on this error the 1st object attempted to compare, and the scenario is this.
This worked:
2 Oracle EBS Instances, both running on 12.1.0.2.0, and connecting to both instances as apps. Compare a database package body (ottomint.pkb), and successfully see the results.
What did not work:
Source Oracle EBS Instance running on 12.1.0.2.0, and destination connection is on Oracle EBS 19.0.0.0.0. Again connecting to both instances as apps.
When attempting to compare the same DB object (ottomint.pkb) as described above, receive:
Unable to compare objects.
Ensure that you have the required permissions.
You must own the objects or have select_catalog_role.
I can open this object with the APPS user. As another test, used a different package POR_CUSTOM_PKG, and it worked as expected. Other item to note, there is only 1 difference in the package that did not work between the 2 instances, which is just the version. All code lines match.
/* $Header: ottomint.pkb 120.43.12010000.28 2017/11/20 05:21:54 ramsanth ship $ */
/* $Header: ottomint.pkb 120.58.12020000.16 2017/12/17 10:17:19 ramsanth ship $ */
-
So you're looing in as APPS in both databases for the compare? If so, sounds like a bug.
-
Yes, APPS in both instances.
-
if you have access to My Oracle Support, please file an SR. Be sure to tell them we think it may be APPS/eBiz specific.
-
I have the same problem
Database diff or cart diff for one package only gives the error:
Unable to compare objects.
Ensure that you have the required permissions.
You must own the objects or have select_catalog_role.
Both databases same 19.5 version
-
I' ve got such error for only the tables which have xmltype column.