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. Should EXT01 have tables defined?

    Should EXT01 have tables defined?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    You see these errors in the www_server log when trying to access a database via z39.50 through the ALEPH OPAC:

    Oracle error: update_cursor z52
    ORA-00942: table or view does not exist

    tab_base.eng shows EXT01 as the "Library connected to"....

    Should the EXT01 have a z52 table defined? (It doesn't have any tables defined.)

    Resolution:
    The EXT01 and EXT02 are "virtual libraries"; they don't, and aren't supposed to, have any Oracle tables.

    The tab_base.eng column 7 ("Library connected to") value needed to be moved one position to the right; it was looking for "XT01 " as the library instead of "EXT01".

    Additional Information

    faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Should ext01 and ext02 be in a-tree or u-tree?
      • Should Oracle database sessions be killed at OS level or within the database?
    • Was this article helpful?

    Recommended articles

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