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

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

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