Customizing Unload Processing for Table Partitions
Customizing Unload Processing for Table Partitions
For partitioned source tables, Fast Clone selects all partitions by default for unload processing. You can exclude certain partitions. Also, for the partitions that you select, you can write the unloaded data to separate output files.
Click the
Source Table Partitions
tab.
The following image shows this tab:
Under
Table
, select a partitioned source table for which to exclude some partitions from unload processing.
The table partitions appear in the
Table Partitions
box.
To exclude a table partition, clear the check box in the partition row.
If you want to exclude most table partitions, click
Select None
to clear all partitions and then select the few that you want to include. Click
Select All
to include all of the partitions again.
To write the source data that is unloaded from each selected table partition to a separate output data file, select the
Export table by partition
option.
This option is cleared by default. With the default setting, Fast Clone uses the
Export by partitions when all selected
option on the
Runtime Settings
tab >
Miscellaneous Conditions
view to determine whether to write the source data from all table partitions to separate data files.