How To Stop A Running Datapump Job Started In Background [ID 958532.1]
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 and later [Release: 10.1 and later ]Information in this document applies to any platform.
Goal
The goal of this document is to demonstrate how a running Datapump job can be stopped.Suppose a session has started a Datapump export operation using the following UNIX command:
$ nohup expdp parfile=test.par &
The example in the document demonstrates how to stop this job from further processing. The same principles apply to jobs initiated using the DBMS_DATAPUMP API.
Solution
To stop the running job the name of the job must first be retrieved. This can be done using:connect / as sysdba
select owner, job_name from dba_datapump_jobs;
Once the job name is known, that particular job can be stopped by interactively attaching to that job using the ATTACH command line option of Datapump and then stop the job. The following example demonstrates this. The sample assumes that the owner of the job is SCOTT and the job name is TEST, so in this case EXPDP must connect to the SCOTT schema and attach to the TEST job:
$ expdp scott/tiger attach=test
Export: Release 11.2.0.1.0 - Production on Sat Oct 24 12:47:28 2009
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 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Job: TEST
Owner: TEST
Operation: EXPORT
Creator Privs: TRUE
GUID: 76AA1EE3F300E784E040B10A543B0825
Start Time: Saturday, 24 October, 2009 12:47:28
Mode: SCHEMA
Instance: ORA11GR2
Max Parallelism: 0
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND scott/******** parfile=test.par
State: DEFINING
Bytes Processed: 0
Job Error Count: 0
Dump File: /u02/app/oracle/admin/ORA11GR2/dpdump/test_23oct_rr.dmp
bytes written: 4,096
Export>
Once attached to the job interactively you can manipulate the job. In order to stop the job from running, the STOP_JOB command should be issued. When activated, the command asks for comfirmation. The answer "yes" should be provided to really stop the job:
Export> stop_job=immediate
Are you sure you wish to stop this job ([yes]/no): yes <<==
The DBA_DATAPUMP_JOBS view can be queried again to see that the job is not running anymore:
SQL> select job_name,state from dba_datapump_jobs;
JOB_NAME STATE
--------------------- -------------------------
TEST NOT RUNNING[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/161195/viewspace-1057043/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORCLE 如何停止一個JOB【HOW TO STOP A JOB IN THE ORACLE?】薦Oracle
- Stop runnung job
- How to change the background color for PyCharmPyCharm
- How to CANCEL a query running in another session?Session
- Import Datapump Job fails with ORA-39125ImportAI
- SharePoint 2013 workflows stop working (Failed on started.)AI
- Keep processes running in the background and even after SSH session disconnectsSession
- job任務均不執行,手工執行報job now running
- how to kill the runing job in ORACLEOracle
- How to set up Software raid1 configuration on a running systemAI
- How to get Timer Job History
- Python程式碼解析: job = next(job for job in jobs if job.job_id == job_id)Python
- 清除dba_datapump_jobs中的孤兒資料泵job
- Oracle OCP 1Z0 053 Q453(STOP_JOB)Oracle
- Oracle DataPump Quick Start [ID 413965.1]OracleUI
- android view background 問題AndroidView
- squid!Your cache is running out of fileUI
- 10 Guidelines for Better Website Background VideosGUIIDEWeb
- 【DATAPUMP】使用DataPump遷移Oracle資料庫Oracle資料庫
- jQuery stop()jQuery
- stop and stare
- 【metalink】Export/Import DataPump Parameter TRACE (文件 ID 286496.1)ExportImport
- 在 Android 上使用協程(二):Getting startedAndroid
- How To Kill Good IdeasGoIdea
- about datapump parallelParallel
- Speedup Datapump ImportImport
- crsctl start/stop crs and crsctl start/stop cluster 區別
- 【ASK_ORACLE】刪除DBA_DATAPUMP_JOBS檢視中的異常資料泵JOB的方法Oracle
- Beaglebone - Getting Started
- Connected to an idle instance – while database is runningWhileDatabase
- How to compile Invalid Object?CompileObject
- background-clip 和 background-origin
- DataPump Export (EXPDP) Fails With Error LPX-216 Invalid CharacterExportAIError
- datapump簡介(一)
- Oracle DataPump之二Oracle
- Oracle DataPump之一Oracle
- Oracle Datapump 學習Oracle
- WPF Grid background ImageBrush ImageSource via image url in MVVMMVVM