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. Can "Export Database Tables" be used to back up an individual table?

    Can "Export Database Tables" be used to back up an individual table?

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

    Description:
    Various KB records say to use p_file_03 to back up a table before updating it (via a batch job or SQL).

    But the only GUI Service I see which refers to "file-03" is this "Export Database Tables". Is this really what I should be using?

    If so, what values should I specify in the submission?

    Resolution:
    p_file_03 is a utility to back up files. It has an option to back up ALL files for the library. You could use this "ALL" option and ftp the output to a different Aleph instance -- that is "exporting".

    But p_file_03 can also be used to "export" (back up) an individual table. That is what you need to do.

    The following are the values you should specify:

    Procedure to run: Go (the default)
    Number of records: 999999999 (the default)
    File format: Fixed (the default)


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Campus-specific Syndetics usage statistics
      • Can a BIB record be automatically locked when opened?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. contype:kba
      2. Prod:Aleph
      3. 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