Home › Discussions › Questions & Answers › ORA-00001: unique constraint violated during compilation

ORA-00001: unique constraint violated during compilation

Avatar photoCustomer Questions & Answers 3 replies

The installation log shows warnings related to ORA-00604 and specifically ORA-00001: unique constraint (SYS.I_OBJAUTH1) violated when a package is being recompiled.

3 replies

  • Support Enginatics

    This violation happens during recursive SQL execution while attempting to grant privileges during the package compilation process. This requires a manual intervention.

  • Avatar photoCustomer

    What is the recommended workaround to resolve this for the failing package, for instance, XXEN_UTIL?

  • Support Enginatics

    You must manually drop and recreate the failing package. Log into SQL*Plus as the APPS user, execute drop package XXEN_UTIL;, and then run the package specification and body scripts (@XXEN_UTIL.pks and @XXEN_UTIL.pkb) from the installer’s SQL directory.

  • You must be logged in to reply to this post.