KILL Data Pump
Da wiki.gienne.cloud.
Versione del 9 apr 2018 alle 16:52 di Admin (Discussione | contributi)
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