在一般的导入导出中,使用:
expdp system/oracle directory=exp_dir dumpfile=sss.dmp schemas=sss logfile=sss.log
使用parfile
expdp parfile=parfilename
排除某些用户下的某些表:
userid=system/oracle
schemas=username
directory=DMPDATA
dumpfile=username_201412122.dmp
logfile=username_201412122.log
EXCLUDE=TABLE:"IN('TBL_ACCOUNT_INF_BAK','TBL_RPT_CARD_RESERVE_DAILY','TBL_TOTAL_CARD_INF','TBL_NODE_SEDFUND','TBL_RPT_CARD_DETAIL_NODE','TBL_BASE_DATA')"
只导出某个用户下的某些表:
userid=system/oracle
schemas=username
directory=DMPDATA
dumpfile=username_20141212_tbl.dmp
logfile=username_20141212_tbl.log
include=TABLE:"IN('TBL_ACCOUNT_INF_BAK','TBL_RPT_CARD_RESERVE_DAILY','TBL_TOTAL_CARD_INF','TBL_NODE_SEDFUND','TBL_RPT_CARD_DETAIL_NODE','TBL_BASE_DATA')"
导出多个用户的对象:
userid=system/oracle
schemas=AAA,BBBB,CCC
directory=DMPDATA
dumpfile=excludeccc_20141212_tbl.dmp
logfile=excludeccc_20141212_tbl.log