Killing a Data Pump Job

Another lesson learned in using Oracle 11g Data Pump was being able to attach and kill an existing Data Pump job using the ATTACH command.  This is done either during the existing Data Pump job by using Ctrl-C to get the prompt and executing the KILL_JOB command:

% expdp / full=y dumpfile=dp_test.dmp logfile=dp_test.log directory=expdumpdir job_name=dp_fullexp

Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 16 January, 2010 13:36:18

Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
Starting "OPS$ORACLE"."DP_FULLEXP":  /******** full=y dumpfile=dp_test.dmp logfile=dp_test.log directory=expdumpdir job_name=dp_fullexp
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

^C
Export>  kill_job
Are you sure you wish to stop this job ([yes]/no): yes

Or you can attach from a separate session and kill the job from there by executing the KILL_JOB command:

% expdp / attach=ops\$oracle.dp_fullexp

Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 16 January, 2010 13:54:00

Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production

Job: DP_FULLEXP
Owner: OPS$ORACLE
Operation: EXPORT
Creator Privs: FALSE
GUID: 7D4BF0976ED665ABE04400144FA165B2
Start Time: Saturday, 16 January, 2010 13:52:07
Mode: FULL
Instance: d105
Max Parallelism: 1
EXPORT Job Parameters:
Parameter Name      Parameter Value:
CLIENT_COMMAND     /******** full=y dumpfile=dp_test.dmp
logfile=dp_test.log directory=expdumpdir
job_name=dp_fullexp
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /disk01/oraexport/dp_test.dmp
bytes written: 4,096

Worker 1 Status:
State: EXECUTING

Export> kill_job
Are you sure you wish to stop this job ([yes]/no): yes

In your original Data Pump session, you will see the job has been terminated:

% expdp / full=y dumpfile=dp_test.dmp logfile=dp_test.log directory=expdumpdir job_name=dp_fullexp

Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 16 January, 2010 13:52:03

Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
Starting "OPS$ORACLE"."DP_FULLEXP":  /******** full=y dumpfile=dp_test.dmp logfile=dp_test.log
directory=expdumpdir job_name=dp_fullexp
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

Job "OPS$ORACLE"."DP_FULLEXP" stopped due to fatal error at 13:54:18

Advertisements

2 Responses to Killing a Data Pump Job

  1. […] This post was mentioned on Twitter by Wataru Morohashi, Wataru Morohashi. Wataru Morohashi said: Reading: Killing a Data Pump Job « Mike R's Blog http://bit.ly/aWlzAH […]

  2. […] filed under Administration, Oracle, Tools. You can follow any responses to this entry through the RSS 2.0 […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: