关键词: expdp,impdp,parallel,partition_options=merge,departition
ORACLE Release 11.2.0.3.0 to Release 11.1.0.7.0
SUSE Linux Enterprise Server 10 SP2 (x86_64)
impdp的PARTITION_OPTIONS参数可以有3个值 DEPARTITION, MERGE and [NONE].默认值是NONE

PARTITION_OPTIONS=[NONE | DEPARTITION | MERGE]
A value of none creates tables as they existed on the system from which the export operation was performed. You cannot use the none option or the merge option if the export was performed with the transportable method, along with a partition or subpartition filter. In such a case, you must use the departition option.
A value of departition promotes each partition or subpartition to a new individual table. The default name of the new table will be the concatenation of the table and partition name or the table and subpartition name, as appropriate.
A value of merge combines all partitions and subpartitions into one table.

上面的意思是说,分区表的导入一般默认用NONE参数,源库什么样,导入目标库也一摸一样的结构,这就要求我们提前准备好一样的表空间,有时候很不方便。
如果用merge参数,所有分区数据导入一个普通的非分区表,用departition参数,则每个分区导入目标库后,变成单独的表,这岂不十分有用,对于测试环境创建,不需要提前准备表空间了,必须试试这个参数。
测试思路:先找个分区表,kr.tr_total_operation_d,用数据泵并行导出,然后把dump文件scp到测试库,
再impdp进去,导入到用户kettle2,表分区合并,表分区departition分别试试,表空间映射到不同表空间,从TBS_KR到TBS_ETL_WEB

Continue reading