Visualizza wikitesto di 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