STOP_JOB :-
This command stops the current job execution and exits the client. STOP_JOB=IMMEDIATE performs an immediate shutdown of Data Pump job.
Cancelling the client process does not stop the associated data pump job. Issuing “ctrl+c” on the client during a job execution doesn’t stops the job running,use STOP_JOB in export or import command utility.
[oracle@18c ~]$ expdp system/oracle directory=DATA_PUMP_DIR dumpfile=emp_prod18c.dmp logfile=emp_prod18c.log Export: Release 18.0.0.0.0 - Production on Mon Aug 20 22:02:43 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=DATA_PUMP_DIR dumpfile=emp_prod18c.dmp logfile=emp_prod18c.log Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA ^C Export> STATUS Job: SYS_EXPORT_SCHEMA_01 Operation: EXPORT Mode: SCHEMA State: EXECUTING Bytes Processed: 0 Current Parallelism: 1 Job Error Count: 0 Job heartbeat: 1 Dump File: /u01/app/oracle/admin/prod18c/dpdump/emp_prod18c.dmp bytes written: 28,672 Worker 1 Status: Instance ID: 1 Instance name: prod18c Host name: 18c.localdomain.com Object start time: Monday, 20 August, 2018 22:02:43 Object status at: Monday, 20 August, 2018 22:02:45 Process Name: DW00 State: EXECUTING Export> STOP_JOB Are you sure you wish to stop this job ([yes]/no): yes
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
