结束oracle import,Oracle 结束 imp/exp 和 expdp/impdp 进程的正确方法
在之前寫的博客里講過Oracle 10g 開始引入的數據泵功能：
Oracle 10g Data Pump Expdp/Impdp 詳解
https://www.cndba.cn/Dave/article/1278https://www.cndba.cn/dave/article/2844
https://www.cndba.cn/dave/article/2844
在文章里提到， 數據泵(expdp/impdp)實際的工作是在數據庫服務端后臺以JOB形式執行，也就是說我們執行數據泵命令實際上在數據庫后臺創建了一個JOB。 因此，加入我們想終止數據泵的工作，就不能向傳統的導出導入命令(exp/imp), 直接kill進程就可以了。 要想kill 數據泵命令，必須連到后臺進行操作。 https://www.cndba.cn/dave/article/2844
一般來說，expdp/impdp 命令有一個參數：job_name=cndba, 如果沒有指定這個參數，那么就需要通過DBA_DATAPUMP_JOBS試圖來查詢。
SQL> 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 UNDEFINED 1 1 2
另外expdp/impdp在執行時，有一個交互模式，在執行命令窗口，按Ctrl+C就可以進入交互模式，在交互模式，可以執行kill_job命令來結束expdp/impdp命令，否則他還會在后頭繼續執行。
[dave@www.cndba.cn ~]$ expdp system/oracle directory=DUMP_DIR full=y
Export: Release 11.2.0.4.0 - Production on Fri Jun 8 16:24:14 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/******** directory=DUMP_DIR full=y
Estimate in progress using BLOCKS method...
^C
Export> status
Job: SYS_EXPORT_FULL_01
Operation: EXPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /backup/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Export> kill_job
Are you sure you wish to stop this job ([yes]/no): yes
[dave@www.cndba.cn ~]$
如果當前執行的終端窗口已經關閉了，還可以通過expdp/impdp的ATTACH來連接到之前的JOB。
https://www.cndba.cn/dave/article/2844https://www.cndba.cn/dave/article/2844
[dave@www.cndba.cn ~]$ expdp system/oracle attach=SYS_EXPORT_FULL_01
Export: Release 11.2.0.4.0 - Production on Fri Jun 8 16:28:06 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Job: SYS_EXPORT_FULL_01
Owner: SYSTEM
Operation: EXPORT
Creator Privs: TRUE
GUID: 6E1E2C8095271134E0535601A8C0D110
Start Time: Friday, 08 June, 2018 16:27:45
Mode: FULL
Instance: cndba
Max Parallelism: 1
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND system/******** directory=DUMP_DIR full=y
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /backup/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Name: +*
Object Type: DATABASE_EXPORT/TRUSTED_DB_LINK
Completed Objects: 1
Total Objects: 1
Worker Parallelism: 1
Export> kill_job
Are you sure you wish to stop this job ([yes]/no): yes
[dave@www.cndba.cn ~]$
Expdp/impdp命令的更多交互命令可以通過help進行查看，如下：https://www.cndba.cn/dave/article/2844https://www.cndba.cn/dave/article/2844
Export> help
------------------------------------------------------------------------------
The following commands are valid while in interactive mode.
Note: abbreviations are allowed.
ADD_FILE
Add dumpfile to dumpfile set.
CONTINUE_CLIENT
Return to logging mode. Job will be restarted if idle.
EXIT_CLIENT
Quit client session and leave job running.
FILESIZE
Default filesize (bytes) for subsequent ADD_FILE commands.
HELP
Summarize interactive commands.
KILL_JOB
Detach and delete job.
PARALLEL
Change the number of active workers for current job.
REUSE_DUMPFILES
Overwrite destination dump file if it exists [N].
START_JOB
Start or resume current job.
Valid keyword values are: SKIP_CURRENT.
STATUS
Frequency (secs) job status is to be monitored where
the default [0] will show new status when available.
STOP_JOB
Orderly shutdown of job execution and exits the client.
Valid keyword values are: IMMEDIATE.
版權聲明：本文為博主原創文章，未經博主允許不得轉載。
總結
以上是生活随笔為你收集整理的结束oracle import,Oracle 结束 imp/exp 和 expdp/impdp 进程的正确方法的全部內容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： SpringMVC工作原理
- 下一篇： matlab程序生成.dll,matla