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

ORA-00001: unique constraint violated during compilation

Avatar photoCustomer January 20, 2022 at 9:22 am

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.

Viewing 2 reply threads
  • Author
    Replies
    • Support January 22, 2022 at 12:06 pm  

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

    • Avatar photoCustomer January 24, 2022 at 12:01 pm  

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

    • Support January 24, 2022 at 3:58 pm  

      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.

Viewing 2 reply threads
  • You must be logged in to reply to this post.

Login with: