oracle impdp/expdp

select * from dba_directories;

create directory datamove1(directory_name) as ‘/oracle/expf’;

grant read,write on directory datamove1 to system(user);

4、删除：drop directory DATACHK_DUMP;

create directory DATABAK as ‘/opt/oracle/oradata/portal/dumpdata’;

create user wantsys identified by manager;
grant connect,resource,dba to wantsys;

grant read,write on directory DATABAK to wantsys;

expdp wantsys/manager DIRECTORY=EXDPDATA parallel=2 DUMPFILE=181exp20200403.dmp logfile=181exp20200403.log schemas=DS,HREMP,TEMPORG,PORTAL,BANKSERVICE,FIXED,DHP,CONTRACT

------12c–根据用户导出，也需要用户名添加实例
expdp wantsys/manager@ww2pdb directory=DATA_DUMP schemas=assessment dumpfile=assessment202006.dmp logfile=assessment202006.log;

create user wantsys identified by manager;
grant connect,resource,dba to wantsys;

grant read,write on directory EXDPDATA to wantsys;

查看视图dba_datapump_jobs

select job_name,state from dba_datapump_jobs;

终止expdp
ctrl+c
stop_job=immediate
yes

退出后台查看方法
1、查看备份job
select job_name,state from dba_datapump_jobs;
2、在退出导出监视界问面答后，可以通过下面语句重新打开expdp界面
Expdp system/test ATTACH=system.export_job10 --第一步查出的job名称
3、结束job
Export>stop_job=immediate或者
Export> kill_job