Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Odd triggers (such as "BIN$Yn47jdhWvjTgQAEKDutM1A") in v19 xxx30

    Odd triggers (such as "BIN$Yn47jdhWvjTgQAEKDutM1A") in v19 xxx30

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 19.01

    Description:
    util a/17/6/4 ("Show Trigger Status") in our v19 abc30 Course Reserve library shows triggers like these:

    TRIGGER_NAME TABLE_NAME STATUS
    ------------------------------ ------------------------------ --------
    BIN$Yn47jdhWvjTgQAEKDutM1A==$0 BIN$Yn47jdhZvjTgQAEKDutM1A==$0 ENABLED
    BIN$Yn47jdhXvjTgQAEKDutM1A==$0 BIN$Yn47jdhZvjTgQAEKDutM1A==$0 ENABLED
    BIN$Yn47jdhYvjTgQAEKDutM1A==$0 BIN$Yn47jdhZvjTgQAEKDutM1A==$0 ENABLED

    Resolution:
    This is the result of running p_union_01 / p_union_02 with the z127 triggers defined. When you do this, the trigger_name and table_name are changed to those shown above.

    In order to avoid this, you can drop the z127 triggers with the following SQL commands prior to running p_union_01 / p_union_02:

    > s+ abc30
    SQL> drop trigger z127_trigger;
    SQL> drop trigger z127_trigger_1;
    SQL> drop trigger z127_trigger_2;

    Then, after p_union_01 / p_union_02 is done, recreate the triggers via the util a/17/6/1/1 ("Create/Recreate ALL Library Triggers").

    These bogus "BIN$..." triggers do no harm: despite their presence, you *can* still do util a/17/16/1 to create the proper z127 triggers.

    You can not delete them with the SQL delete command. You need to do the following:

    > s+ abc30
    SQL> select * from user_recyclebin; [not necessary, but it shows you what you are purging with the following purge command]
    SQL> purge recyclebin;

    (Thanks to Al Rykhus, at PALS-MnLink, for supplying this purge command.)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Oct 2009 Oracle Critical Patch Update
      • Odd z71_user_name created during file-96 load
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 19.01
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved