Oracle数据泵-管理1

create directory dump_dir as /bossdata/expdir;
grant read,write on directory dump_dir to sms3;
select * from dba_directories; 


nohup expdp system/system directory=dump_dir   parallel=5 job_name=cases_export logfile=expdp20130620.log SCHEMAS=sms3 dumpfile=expdp_%u.dmp FILESIZE=5000m &


nohup impdp sms3/sms3  directory=DUMP_DIR dumpfile=expdp_%u.dump logfile=impdp20130620.log  parallel=10  job_name=impdp  remap_schema=sms3:sms3 &


nohup impdp system/system directory=DMP_DIR dumpfile=20130620sms3.dmp logfile=impdp.log parallel=7 &
expdp QUESTFLA/questfla directory=DUMP_DIR  flashback_scn=    PARFILE='/home/oracle/SGPMS.par'  parallel=10 job_name=cases_export logfile=dd.log dumpfile=expdp_%u.dmp FILESIZE=5000m
impdp  system/system  directory=DUMP_DIR dumpfile=expdp_%u.dmp logfile=ddd.log  parallel=10  job_name=impdp  remap_schema=sms3:sms3




如果出现乱码


lang=C