执行expdp/impdp操作时，如果中途发现执行错误或者其他原因需要取消时，不能直接通过ctrl+c或者关闭操作窗口进行取消。使用以上操作取消后，expdp/impdp进程仍然在运行中。
[[email protected] ~]$ expdp userid='/ as sysdba' dumpfile=full.dmp logfile=full.log directory=dump_dir full=y
Export: Release 11.2.0.4.0 - Production on Fri Jan 12 18:00:08 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_FULL_01": userid="/******** AS SYSDBA" dumpfile=full.dmp logfile=full.log directory=dump_dir full=y
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 370.6 MB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
^C
[[email protected] ~]$ du -sk *
956 full.dmp
4 full.log
[[email protected] ~]$ du -sk *
1040 full.dmp
4 full.log
我们发现dmp文件一直在增长，此时如果需要停止该JOB。
expdp userid='/ as sysdba' attach=SYS_EXPORT_FULL_01
Export> stop_job
Are you sure you wish to stop this job ([yes]/no): yes
[[email protected] ~]$
[[email protected] ~]$ du -sk *
25260 full.dmp
8 full.log
[[email protected] ~]$ du -sk *
25260 full.dmp
8 full.log
正常停止后dump文件不再增长。
转载于:https://my.oschina.net/u/3761438/blog/1608626