手动中止expdp和impdp

在数据泵导出导入的时候,如果想中止,及时关闭窗口任务仍会执行,只能等到结束才能再次执行,分享一下手工结束的方式
;;;
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
手动中止expdp和impdp
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



