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;