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. OPAC not working: "Can not perform DDL/DML over objects in Recycle Bin"

    OPAC not working: "Can not perform DDL/DML over objects in Recycle Bin"

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

    Description:
    The www_server stopped working last night. OPAC searches yield the following messages in the www_server log:

    Oracle error: io_z63_write
    ORA-38301: can not perform DDL/DML over objects in Recycle Bin
    ...
    Oracle error: io_z63_update
    ORA-38301: can not perform DDL/DML over objects in Recycle Bin

    The clear_vir01 from last night has the following messages:

    Elapsed: 00:00:00.03
    04:00:40 aleph_admin@ALEPH0>
    Table dropped.

    Elapsed: 00:00:00.31
    CREATE TABLE VIR01.Z63 (
    *
    ERROR at line 1:
    ORA-00955: name is already used by an existing object

    Elapsed: 00:00:00.00
    04:00:40 aleph_admin@ALEPH0> CREATE UNIQUE INDEX VIR01.Z63_ID ON VIR01.Z63 (Z63_
    REC_KEY ASC)
    *
    ERROR at line 1:
    ORA-01408: such column list already indexed
    <etc.>

    An attempt to do util a/17/1 for the z63, individually, gives similar messages.

    Resolution:
    The Oracle recycle bin can be used to recover accidentally deleted files. As delivered, the Aleph Oracle is set to have this feature turned off, but there was a build in 2006 which was distributed with recyclebin = on.

    Do the following, as the oracle user,

    sqlplus '/ as sysdba'

    SQL> purge recyclebin;

    Note: Each Oracle user (each Aleph library) has its own recyclebin.
    You would need to connect to each library to do the purge.
    The main concern is the VIR01 recyclebin, which gets 100 times the use of any other.

    This should stop any immediate problem.

    Then, to see how recyclebin is set:

    SQL> sho parameter recyclebin

    If it's OFF, there's nothing more to do. If it is ON, then you need to:

    1. purge the recyclebin (see above)

    and

    2. turn recyclebin OFF:

    SQL> ALTER SYSTEM SET recyclebin = OFF scope=BOTH;

    Note: Once recyclebin is set to OFF (and the purge has been done), Oracle won't try to write to them any more.
    The "ALTER SYSTEM SET recyclebin = OFF scope=BOTH;" will set *all* of the recyclebins to OFF.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • OPAC not always display full field
      • OPAC page displayed when library is locked
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.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