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

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

    • 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