首页 > 应用开发 > IT综合 > How To Stop A Running Datapump Job Started In Background [ID 958532.1]

How To Stop A Running Datapump Job Started In Background [ID 958532.1]

原创 IT综合 作者:msdnchina 时间:2012-01-05 17:09:50 0 删除 编辑

Applies to:

Oracle Server - Enterprise Edition - Version: and later [Release: 10.1 and later ]
Information in this document applies to any platform.


The goal of this document is to demonstrate how a running Datapump job can be stopped.

Suppose a session has started a Datapump export operation using the following UNIX command:

$ nohup expdp parfile=test.par &

The example in the document demonstrates how to stop this job from further processing. The same principles apply to jobs initiated using the DBMS_DATAPUMP API.


To stop the running job the name of the job must first be retrieved. This can be done using:

connect / as sysdba
select owner, job_name from dba_datapump_jobs;

Once the job name is known, that particular job can be stopped by interactively attaching to that job using the ATTACH command line option of Datapump and then stop the job. The following example demonstrates this. The sample assumes that the owner of the job is SCOTT and the job name is TEST, so in this case EXPDP must connect to the SCOTT schema and attach to the TEST job:

$ expdp scott/tiger attach=test
Export: Release - Production on Sat Oct 24 12:47:28 2009

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Owner: TEST
Operation: EXPORT
Creator Privs: TRUE
GUID: 76AA1EE3F300E784E040B10A543B0825
Start Time: Saturday, 24 October, 2009 12:47:28
Instance: ORA11GR2
Max Parallelism: 0
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND scott/******** parfile=test.par
Bytes Processed: 0
Job Error Count: 0
Dump File: /u02/app/oracle/admin/ORA11GR2/dpdump/test_23oct_rr.dmp
bytes written: 4,096


Once attached to the job interactively you can manipulate the job. In order to stop the job from running, the STOP_JOB command should be issued. When activated, the command asks for comfirmation. The answer "yes" should be provided to really stop the job:

Export> stop_job=immediate
Are you sure you wish to stop this job ([yes]/no): yes <<==

The DBA_DATAPUMP_JOBS view can be queried again to see that the job is not running anymore:

SQL> select job_name,state from dba_datapump_jobs;

--------------------- -------------------------

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: 再见,2011
请登录后发表评论 登录


  • 博文量
  • 访问量