KILL Data Pump

Query per retrive ID Datapump: (nella exp mettere sempre: JOB_NAME=EXP_FULL)

select owner_name, job_name, state from dba_datapump_jobs;

Reperire il job_name

expdp utentealncio/password@DB attach=SYS_EXPORT_SCHEMA_01

Export: Release 11.2.0.3.0 - Production on Mon Apr 9 14:24:44 2018

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option

Job: SYS_EXPORT_SCHEMA_01
  Owner: SYSTEM
  Operation: EXPORT
  Creator Privs: TRUE
  GUID: 6969D8BEF02D90FEE053975C0E99A6E8
  Start Time: Monday, 09 April, 2018 13:38:38
  Mode: SCHEMA
  Instance: dwhprd
  Max Parallelism: 2
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        system/********@dwhprd parfile=****.par logfile=****.log
    METRICS               1
 State: EXECUTING
 Bytes Processed: 78,688,959,712
 Percent Done: 10
 Current Parallelism: 2
 Job Error Count: 0
 Dump File: /oracle_export_tmp/exp_dwh_12t_%u.dm***
   bytes written: 4,096
 Dump File: /oracle_export_tmp/e**
   bytes written: 78,696,472,576

Worker 1 Status:
 Process Name: DW00
 State: EXECUTING
 Object Schema: ***
 Object Name: ***
 Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
 Completed Objects: 4
 Total Objects: 2,960
 Completed Rows: 6,975,574
 Worker Parallelism: 1

Worker 2 Status:
 Process Name: DW01
 State: EXECUTING
 Object Schema: MVDWMA
 Object Name: DWJSU10F_TBD
 Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
 Completed Objects: 1
 Total Objects: 2,960
 Completed Rows: 289,127,149
 Worker Parallelism: 1

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