[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 746
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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