impdp如何杀掉job

时间：2021-02-22 16:17:08

今天刚执行一个impdp操作发现，硬盘空间可能不够了，赶紧按了Ctrl+C，结果发现磁盘空间仍然在减少。问了一下部门oracle专家，Ctrl+C是无法停止impdp的job的。需要将job进行attach操作，然后kill。过程如下：

1、现在数据库中查找视图，得到job的名称

 select * from dba_datapump_jobs;

impdp如何杀掉job

2、得到Job名称之后登陆数据库服务器，执行如下命令

$ impdp \"/ as sysdba\" attach=SYS_IMPORT_FULL_01

Import: Release 11.2.0.4.0 - Production on Wed Feb 28 19:34:02 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_IMPORT_FULL_01

  Owner: SYS

  Operation: IMPORT

  Creator Privs: TRUE

  GUID: 6644D99D3900436BE0530B1310ACE6EF

  Start Time: Wednesday, 28 February, 2018 19:14:44

  Mode: FULL

  Instance: sicsdb

  Max Parallelism: 1

  EXPORT Job Parameters:

  Parameter Name      Parameter Value:

     CLIENT_COMMAND        "/******** AS SYSDBA" dumpfile=aaa.dmp schemas=SICSPC_INT

  IMPORT Job Parameters:

     CLIENT_COMMAND        "/******** AS SYSDBA" dumpfile=aaa.dmp remap_tablespace=111:222 remap_schema=1:2 EXCLUDE=INDEX

  State: EXECUTING

  Bytes Processed: 28,836,139,448

  Percent Done: 88

  Current Parallelism: 1

  Job Error Count: 0

  Dump File: /u01/app/admin/aaadb/dpdump/aaa.dmp

Worker 1 Status:

  Process Name: DW00

  State: EXECUTING

  Object Schema: UAT_EST

  Object Name: PERIOD_SNL_EST_201705

  Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA

  Completed Objects: 17

  Completed Rows: 1,385,265

  Completed Bytes: 180,716,256

  Percent Done: 87

  Worker Parallelism: 1

3、 然后会自动进入impdp的命令行，再执行kill操作即可。

Import> kill

Are you sure you wish to stop this job ([yes]/no): yes

相关文章