Your Doorstep to the Temple of Oracle

Oracle EBS

How to Kill or Cancel a expdp Job

Posted by appsdba11i on June 4, 2013

We recently got an option to cancel the Running Expdp.
we have killed the OS level process but it doesnt worked.SO i am giving the process which worked for me

we followd this process to cancel Job

Just Check your Running Job from Database (dba_datapump_jobs).

select job_name,owner_name,state from dba_datapump_jobs;

Get the Name of Job and kill the expdp Job

expdp / attach=JOBNAME

SQL> SELECT owner_name, job_name, operation, job_mode, state FROM dba_datapump_jobs; 2

OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE
————– ——————- —————– ————- ———
SYSTEM SYS_EXPORT_SCHEMA_01 EXPORT SCHEMA EXECUTING

ex:expdp / attach=SYS_EXPORT_SCHEMA_01

bash-3.2$ expdp / attach=SYS_EXPORT_SCHEMA_01
Export: Release 11.2.0.3.0 – Production on Mon Jan 3 11:25:35 2011
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
UDE-01017: operation generated ORACLE error 1017
ORA-01017: invalid username/password; logon denied
Username: system
Password:

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

Job: SYS_EXPORT_SCHEMA_01
Owner: SYSTEM
Operation: EXPORT
Creator Privs: TRUE
GUID: D8HJKIJHNJJHJDMJBNDBN
Start Time: Monday, 01 June, 2011 16:04:23
Mode: SCHEMA
Instance: TEST1
Max Parallelism: 1
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND system/******** dumpfile=scott.dmp directory=backup logfile=exp.log schemas=scott
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/oracle/scott.dmp
bytes written: 19,435,520

Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: SCOTT
Object Name: YHJNSNHSS
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 1
Total Objects: 548
Completed Rows: 110,849,510
Worker Parallelism: 1

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

This will Kill the expdp job

Thanks
Reddy

Advertisements

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

 
%d bloggers like this: