可以使用 kill_job 或 stop_job结束或停止Job , stop的job可以继续,kill的不行。
Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
C:\Users\Administrator>expdp \"/ as sysdba\" attach=SYS_EXPORT_FULL_02
Export: Release 11.2.0.4.0 - Production on 星期三 11月 9 09:27:51 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
作业: SYS_EXPORT_FULL_02
所有者: SYS
操作: EXPORT
创建者权限: TRUE
GUID: 8DFA5426BA474EBEBB07FCA67BC428E9
开始时间: 星期二, 08 11月, 2022 16:57:35
模式: FULL
实例: da
最大并行度: 1
EXPORT 个作业参数:
参数名 参数值:
CLIENT_COMMAND "/******** AS SYSDBA" full=y directory=dir_dp dumpfile=expdp_full20221108.dmp logfile=expdp_full20221108.log compression=all
COMPRESSION ALL
状态: STOP PENDING
处理的字节: 0
当前并行度: 1
作业错误计数: 0
转储文件: J:\DATABASE\EXPDP_FULL20221108.DMP
写入的字节: 27,947,008
Worker 1 状态:
进程名: DW04
状态: EXECUTING
对象方案: EDMSSA
对象名: ORIGINALFILE
对象类型: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
完成的对象数: 1
总的对象数: 1,461
完成的行数: 212,917
Worker 并行度: 1
Export> kill_job
是否确实要停止此作业 ([Y]/N): YES
SQL> DESC DBA_DATAPUMP_JOBS;
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
OWNER_NAME VARCHAR2(30)
JOB_NAME VARCHAR2(30)
OPERATION VARCHAR2(120)
JOB_MODE VARCHAR2(120)
STATE VARCHAR2(30)
DEGREE NUMBER
ATTACHED_SESSIONS NUMBER
DATAPUMP_SESSIONS NUMBER
SQL> SELECT OWNER_NAME,JOB_NAME FROM DBA_DATAPUMP_JOBS;
OWNER_NAME
------------------------------------------------------------
JOB_NAME
------------------------------------------------------------
SYS
SYS_EXPORT_FULL_01
SQL> EXIT
从 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开