Exporting partitions

Partitions can be exported to allow them to be maintained outside of the database.

About this task

Partitions can be exported for a particular date range or for a particular partition.

Procedure

The syntax of the exporting partitions options are as follows: 
part_admin -export -tname <TABLE_NAME> -sdate <DATE> -edate <DATE>

Or,

part_admin -export -pname <TABLE_NAME>:<PART_NAME>

Example

The following example exports partitions in table ERI_BSC_TBF_GSL_TAB from the 1st January 2007 to the 10th January 2007:

part_admin -export -tname ERI_BSC_TBF_GSL_TAB -sdate 2007010100 -edate 2007011000

The following example exports the partition P2007011000 in table ERI_BSC_TBF_GSL_TAB:

part_admin -export -pname ERI_BSC_TBF_GSL_TAB:P2007011000