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. *Master* Oracle Tables Document -- List for Tables with No Regular Z-Table Doc

    *Master* Oracle Tables Document -- List for Tables with No Regular Z-Table Doc

    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, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care

    There's no file for the following Aleph tables in the Ex Libris Documentation Center > Aleph > Technical Documentation > Aleph Oracle Tables .pdf files....

    Z05, Z1003, Z110, Z114, Z130, Z131, Z17
    Z200, Z201, Z302
    Z50, Z51, Z53, Z54, Z55, Z56, Z57, Z59
    Z60, Z603, Z63, Z64, Z65, Z69, Z690
    Z900, Z95, Z950, Z98, Z980

    Is there information for these tables somewhere?

    Resolution:

    Information for each table follows. Links to articles referred to below may be found in Additional Information further below.

    Z05: Temporary vir01 result-set table.  See Article 000043444 (“What is z05?”) and Article 000039215 (“Set shown in www_server log has not corresponding z05. [PRB 8291}”)
    Z1003: Article 000045486 (“What are the z1000, z1001, z1002, and z1003 tables?”)
    Z110: Temporary vir01 result-set table.  Article 000039215 (“Set shown in www_server log has not corresponding z05. [PRB 8291}”)
    Z114: Article 000041459 (“Description of z114”) and Article 000039067 (“z114 in CJK character sorting; obtaining z114; Web Utilities for maintaining”)
    Z130 and Z131:  Temporary vir01tables relating to searching 
    Z17: Obsolete as of Aleph version 16
    Z200: Temporary vir01 table used in ILL processing. See Article 000047071 (“VIR01.Z200_ID unique constraint errors”)
    Z201: Obsolete.
    Z302: Virtual patron table, combining z303 and z304 fields. See Article 000043286 (“What is the Z302 Record?”)
    Z50: Time stamp: for the internal manipulation of data and record locking processes (currently used to control z30 records). Note: must be defined in the file_list of the ADM (xxx50) library.
    Z51: Temporary vir01table relating to searching
    Z53: Obsolete
    Z54: Obsolete
    Z55: Not in use as of v17.
    Z56: ADAM session information
    Z57: Obsolete
    Z59: In 14.2: cataloger profile. Not in use as of 16.2.
    Z60: Article 000037308 (“What is the z60 table?”)
    Z603: Obsolete
    Z63: Web OPAC session table. Article 000036760 (“Can’t log into Web, ‘unique constraint (VIR01.Z63_ID) violated’ *MASTER RECORD*”) and Article 000039007 (“About HTML and Web Pages”) and Article 000046172 (“Can’t log into web after clear_vir01 was run”)
    Z64: WWW-X session table. Article 000033340 (“Z63_TIME, Z64_TIME, Z65_TIME”)
    Z65: GUI session table. See Article 000036887 (“What is the Z65 Oracle Table?”)
    Z69: Article 000039664 (“Z69 table: what is it? How populated/cleaned?”)
    Z690: Replaced by Z69 table in version 16.02.
    Z900: Article 000034237 (“What is the z900 table?”)
    Z95: The records of this table contain the list of words in a document. The ue_01 online indexing process writes the z95 records.
    Z950: This table has been removed and is not used anymore.
    Z98: A keyword index.  See article 000033948 (“p_manage_01: z98_id … unable to extend temp segment in tablespace TS3X”) and Article 000046511 (“ue_01_word: thousands of ‘IO_Z98 OP ERROR – WRITEN’ errors”) and Article 000037557 (“Z98/Z980 tables”) and Article 000042723 (“p_manage_01_e: How To Restart Load of z98”)
    Z980: A temporary version of the z98.  See article 000037557 (“Z98/Z980 tables”)

    See also Article 000036574 (“Which tables are index, temporary, And base tables?”). See link at the end of Additional Information below.

    Additional Information

    What is z05?
    Set shown in www_server log has no corresponding z05. [PRB 8291]
    What are the z1000, z1001, z1002, and z1003 tables?
    Description of z114
    z114 in CJK character sorting; obtaining z114; Web Utilities for maintaining
    Oracle table descriptions
    Union Catalog incorrect search results, the z120 is correct; updates not seen.
    VIR01.Z200_ID unique constraint errors
    What is the Z302 Record?
    About HTML and Web Pages
    What is the z60 table?
     


    Can't log into web after clear_vir01 was run
    Z63_TIME, Z64_TIME, Z65_TIME
    What is the Z65 Oracle Table?
    Z69 table: what is it? how populated/cleaned?
    What is the z900 table?
    p_manage_01: z98_id ... unable to extend temp segment in tablespace TS3X
    ue_01_word: thousands of "IO_Z98 OP ERROR - WRITEN" errors
    Z98/Z980 tables
    Which tables are index, temporary, and base tables?

    Category: System management


    • Article last edited: 1-Aug-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • *Master record for search problems resulting from clear_vir01 problems*
      • <library> is not in WORD_STARTUP_LIBS, ACC_AUT_STARTUP_LIBS, etc.
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Dedicated-Direct
      4. Direct
      5. Local
      6. Prod:Aleph
      7. System management
      8. Total Care
      9. 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