在数据泵导出导入的时候，如果想中止，及时关闭窗口任务仍会执行，只能等到结束才能再次执行，分享一下手工结束的方式

;;; 

Import: Release 11.2.0.4.0 - Production on Thu Jun 13 17:33:54 2019

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, OLAP, Data Mining and Real Application Testing options

Master table "XMCS"."XMCS_IMPDP" successfully loaded/unloaded

Starting "XMCS"."XMCS_IMPDP":  xmcs/******** directory=dmpdir dumpfile=YYGT_20190613.DMP table_exists_action=replace REMAP_SCHEMA=yygt:xmcs remap_tablespace=EAS_D_yygt_STANDARD:EAS_D_xmcs_STANDARD,EAS_D_yygt_temp2:EAS_D_xmcs_temp2,EAS_D_yygt_INDEX:EAS_D_xmcs_INDEX job_name=xmcs_impdp exclude=statistics exclude=table:"in('T_WFR_PROCINSTDATAHST','T_WFR_PROCESSINSTLOG','T_BE_BANKLOG','T_WFR_ACTINSTHST','T_WFR_ASSIGNHST','T_JOB_INSTHST','T_LOG_HIS')" exclude=TABLE:"LIKE'VT%'" LOGFILE=20190613.log 

Processing object type SCHEMA_EXPORT/USER

ORA-31684: Object type USER:"XMCS" already exists

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

. . imported "XMCS"."T_LOG_APP"                          8.666 MB   25823 rows

. . imported "XMCS"."T_NCM_EQUIVALENTCOEF"               849.3 MB 3464885 rows

. . imported "XMCS"."T_WFR_PROCINSTDATA"                 359.9 MB   22090 rows

. . imported "XMCS"."T_AP_OTHERBILLENTRY"                454.7 MB  750419 rows

Ctrc+C;（按完之后会卡一下  不要按两次）

Import>kill_job

yes

Job "LIU"."LIU_IMPDP" stopped due to fatal error at Wed Jul 3 07:50:05 2019 elapsed 0 00:01:41

******************************************************************************************

如果需要终止expdp, 方法同上

;;; 

Export: Release 11.2.0.4.0 - Production on Wed Jul 3 10:43:29 2019

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, OLAP, Data Mining and Real Application Testing options

Starting "FYBX"."SYS_EXPORT_SCHEMA_02":  fybx/******** DIRECTORY=dmpdir DUMPFILE=FYBX_20190703.dmp schemas=fybx logfile=FYBX_20190703.log 

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 7.461 GB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Ctrc+C;

Export> kill_job

yes

Job "FYBX"."SYS_EXPORT_SCHEMA_02" stopped due to fatal error at Wed Jul 3 10:43:46 2019 elapsed 0 00:00:16