• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 823
  • Last Modified:

to kill export process

How we kill an export process ?

after expdp
0
tonydba
Asked:
tonydba
  • 3
  • 2
  • 2
  • +3
2 Solutions
 
slightwv (䄆 Netminder) Commented:
If you only have one expdp running, just rerun expdp with the same username and password then at the expdp prompt:  kill_job

The docs always have the information you need:
http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm#SUTIL200
0
 
Wasim Akram ShaikCommented:
If the job is already running and you are yet to get the prompt then you could simply press

Ctrl + C

and then type

stop_job= immediate

If there are multiple jobs and no prompt is available in your terminal window, then you can query the dba_datapump_jobs data dictionary

SELECT owner_name, job_name, operation, job_mode, state
FROM dba_datapump_jobs;

select the job name from this and then attach yourselves to it before killing it in actual

expdp system/orcl attach=<JOB_NAME>

Agree with Steve, Best Place to start with is Oracle Docs
0
 
DavidSenior Oracle Database AdministratorCommented:
Good answers, so I'll simply joke one can always cut power to the server......
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
slightwv (䄆 Netminder) Commented:
>>so I'll simply joke one can always cut power to the server

Interesting joke...  Will the expdp database job survive a 'shutdown abort'?  Might be worth a quick test?
0
 
Alexander Eßer [Alex140181]Software DeveloperCommented:
Will the expdp database job survive a 'shutdown abort?
Let's bet ;-) I don't think so...
0
 
Wasim Akram ShaikCommented:
no it won't ..!! shut abort.. expdp will lose its track..!! will not resume once the instance is back.. Had already experienced it...!!!
0
 
Alexander Eßer [Alex140181]Software DeveloperCommented:
I know ;-) That was just a rhetorical statement/question ^^
0
 
tonydbaAuthor Commented:
stop_job= immediate
 

is applicable to aix solaris.
0
 
Wasim Akram ShaikCommented:
Yes.. its applicable everywhere aix,Linux,unix   ,, Solaris.. even windows.. its independent of operating system
0
 
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now