Saturday 1 February 2014

How to Kill oracle datapump export job

In oracle expdp and impdp we can Kill job at any moment.Below are the steps how can we kill the datapump job.

17:18:37 dev > select * from dba_datapump_jobs;

OWNER_NAME JOB_NAME OPERATION
------------------------------ ------------------------------ ------------------------------
JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ------------------------------ ---------- ----------------- -----------------
SYSTEM SYS_EXPORT_FULL_01 EXPORT
FULL EXECUTING 1 0 2


17:19:11 dev > !ps -ef | grep expdp
orauat 1945838 2142428 0 17:19:25 pts/0 0:00 grep expdp



$ expdp system/manager attach=SYSTEM.SYS_EXPORT_FULL_01

Export: Release 11.2.0.1.0 - Production on Fri Dec 9 17:23:04 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

Job: SYS_EXPORT_FULL_01
Owner: SYSTEM
Operation: EXPORT
Creator Privs: TRUE
GUID: B3A5B7EACDCC30C8E0430A0B014030C8
Start Time: Friday, 09 December, 2011 14:09:19
Mode: FULL
Instance: dev
Max Parallelism: 1
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND system/******** directory=EXP_dev dumpfile=fulldp_c lone_091211_system.dmp logfile=fulldp_dev_091211_system.log full=y
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /orabackup/EXP_dev/fulldp_dev_091211_system.dmp
bytes written: 4,096

Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: APPS
Object Name: EAM_DEPT_APPROVERS_PUB
Object Type: DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC
Completed Objects: 11,280
Worker Parallelism: 1


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

No comments:

Post a Comment