掌握parfile这个属性，成功分离分区
directory=DP
dumpfile=xx.dmp
logfile=xx.log
schemas=xxxx,xxxx
EXCLUDE=TABLE_DATA:"IN(SELECT distinct DBA_TAB_SUBPARTITIONS.SUBPARTITION_NAME
FROM DBA_TAB_SUBPARTITIONS WHERE TABLE_owner IN ('xxxx','xxxx') and
DBA_TAB_SUBPARTITIONS.subpartition_name not like
'%xxxx%' union all select distinct dba_tab_partitions.partition_name from
dba_tab_partitions where TABLE_owner IN ('xxxx','xxxx') and
dba_tab_partitions.partition_name not like '%xxxx%')"
dumpfile=xx.dmp
logfile=xx.log
schemas=xxxx,xxxx
EXCLUDE=TABLE_DATA:"IN(SELECT distinct DBA_TAB_SUBPARTITIONS.SUBPARTITION_NAME
FROM DBA_TAB_SUBPARTITIONS WHERE TABLE_owner IN ('xxxx','xxxx') and
DBA_TAB_SUBPARTITIONS.subpartition_name not like
'%xxxx%' union all select distinct dba_tab_partitions.partition_name from
dba_tab_partitions where TABLE_owner IN ('xxxx','xxxx') and
dba_tab_partitions.partition_name not like '%xxxx%')"
扫一扫
9982
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
