expdp 导出特定对象

SQL> select segment_name,bytes/1024/1024/1024 Gb from dba_segments where segment_type='TABLE' and bytes/1024/1024/1024>=1 order by bytes/1024/1024/1024 desc;

SEGMENT_NAME GB
---------------------------------------- ----------
SFCS_SN_SITE_STATISTICS 56.75
KP_KEYPART_RUNCARD 23.75
CELL_SORT_INFO_BY_CUSTOMER 20.7246094
WIP_RUNCARD 12.75
KP_KEYPART_FLEX 6.41308594
WIP_RUNCARD_BACKUP 4.3125
APPLE_FCCDATA 3.9375
SFCS_RUNCARD_JUMPER 3.25
KP_KEYPART_FLEX_BACKUP 2.45507813
CELL_SORT_GROUPING_INFO 2.37988281
SFCS_IO_STATISTICS 1.75

SEGMENT_NAME GB
---------------------------------------- ----------
SFCS_DEFECTS 1.75
SFCS_SITE_STATISTICS 1.25
SFCS_REWORK_LOG 1.0625
WIP_RUNCARD_SN_REWORK_LOG 1.0625

--------------------------------------------------------------------------------------------

expdp system/*** DIRECTORY=dumpdir CONTENT=METADATA_ONLY DUMPFILE=smp_NODATA.dmp parallel=10;

[@more@]

stcsmesfab2:ora102:/ora102/oradata >more mypar.par
directory=dumpdir
full=y
dumpfile=fab2.dmp
logfile=fab2_expdp.log
exclude=table:"in (
'SMP.SFCS_SN_SITE_STATISTICS',
'SMP.KP_KEYPART_RUNCARD',
'SMP.CELL_SORT_INFO_BY_CUSTOMER',
'SMP.WIP_RUNCARD',
'SMP.KP_KEYPART_FLEX',
'SMP.WIP_RUNCARD_BACKUP',
'SMP.APPLE_FCCDATA',
'SMP.SFCS_RUNCARD_JUMPER',
'SMP.KP_KEYPART_FLEX_BACKUP'
'SMP.CELL_SORT_GROUPING_INFO',
'SMP.SFCS_IO_STATISTICS',
'SMP.SFCS_DEFECTS'
'SMP.SFCS_SITE_STATISTICS',
'SMP.SFCS_REWORK_LOG',
'SMP.WIP_RUNCARD_SN_REWORK_LOG'
)"
job_name=expdp

expdp smp/*** parfile=mypar.par

expdp smp/******** directory=dumpdir content=METADATA_ONLY dumpfile=big_table.dmp logfile=expbig_table.log tables=
SFCS_SN_SITE_STATISTICS,
KP_KEYPART_RUNCARD,
CELL_SORT_INFO_BY_CUSTOMER,
WIP_RUNCARD,
KP_KEYPART_FLEX,
WIP_RUNCARD_BACKUP,
KP_KEYPART_FLEX_BACKUP,
APPLE_FCCDATA,
SFCS_RUNCARD_JUMPER,
KP_KEYPART_FLEX_BACKUP,
CELL_SORT_GROUPING_INFO,
SFCS_IO_STATISTICS,
SFCS_DEFECTS,
SFCS_SITE_STATISTICS,
SFCS_REWORK_LOG,
WIP_RUNCARD_SN_REWORK_LOG job_name=expdp;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/789833/viewspace-1047308/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/789833/viewspace-1047308/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值