Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    Problems with UTIL A/9

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    When I execute UTIL A/9, I get the following error message:

    error delete:

    ANALYZE TABLE XXX50.Z353 DELETE STATISTICS
    *
    ERROR at line 1:
    ORA-38029: object statistics are locked

    Resolution:
    You need to delete the statistics manually. First log in as ALEPH_ADMIN by typing:

    sqlplus $ALEPH_ADMIN

    Then execute the following command (replace with the relevant library and table):

    exec dbms_stats.unlock_table_stats('XXX50','Z353');

    • Article last edited: 10/8/2013