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. Messy Oracle table for MGU13

    Messy Oracle table for MGU13

    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:
    I was emptying out ABC13 in preparation for loading a new batch of authorites, and ran util a/17/11/1 (Space Utilization in ABC13 - All Oracle tables).

    First it says: make_library_file_list: env file_list_size does not exists. Using data_root/file_list as is

    But the tables list after that are quite different from the file list in ABC13.

    The test server seems okay.

    The prof library settings are the same:
    setenv active_library ABC13
    setenv library_type AUT
    setenv library_size DEMO

    As are the file lists.

    So production's ABC13 table set must have been created before the prof_library was adjusted?

    I know how to delete tables via SQL. Should I do that with all of these ABC13 tables using TS0 rather than our TSnD and TSnX spaces?

    Resolution:
    From Jerry:

    I don't think the Service Pack will make a difference.

    Please try deleting the tables with SQL before running the util:

    s+ abc13

    SQL-ABC13> delete table z00r;
    SQL-ABC13> delete table z0101;
    etc.

    (Make sure you are in abc13 when doing these things.)

    Then do util a/17/1 all.

    [From site:]
    I have removed the unwanted tables from ABC13 on production. Production and test are now in sync.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Message: Commit point reached - logical record count ... in manage_01 and manage_02
      • Metalib ISSN/ISBN doesn't work connecting to ALEPH server.
    • 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