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
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