Export a large amount of Oracle data using multiple dump files

Oracle's data export utility is an important part of the entire backup policy. You can use this tool to restore data from a single data table, which is difficult for conventional data file-based backup.

However, as the number of databases and individual data tables increases, it is quite difficult to create a large enough export file to include the data.

Many database administrators (DBAs) have not realized that they can use multiple output files to save and export data. If a disk partition does not have enough space or the database size exceeds the operating system's limit on the size of a single file, we only need to split it into multiple files.

From Oracle 8i, the FILE parameter can be separated by commas. The FILESIZE parameter can be used to specify how much data is stored in a file and then switched to another file. If the Export program runs out of the FILE names in the FILE list, a message is displayed, prompting you to enter another name.

For example, if exporting the entire database requires 6 GB space, the operating system must be 2 GB. You want to put the data in the prod directory of the/exp file system. The content of the parameter file is as follows:

1 2 Next Page

[Content navigation]
Page 1: using multiple dump files to export a large amount of Oracle Data	Page 1: using multiple dump files to export a large amount of Oracle Data