[Note]--oracle method to terminate the EXPDP/IMPDP process run

normal termination of EXPDP jobs:
Check the job_name first:
SELECT * from Dba_datapump_jobs;
Owner_name job_name Operation Job_mode State degree attached_sessions datapump_sessions
------------------------------------------------------------ ------------------------------ ----------
SYSTEMsys_export_full_01EXPORT full executing 1 1 3

Attach the task:
EXPDP System/sys attach=sys_export_full_01

If it is IMPDP, replace the EXPDP with IMPDP.

Export> Stop_job

Are you sure you want to stop this job ([y]/n): YES

Export> Kill_job

Are you sure you want to stop this job ([y]/n): YES

Ctl+c can enter interactive mode at execution time, both Windows and Linux are the same.

When you re-enter EXPDP/IMPDP, you can perform the following interactive commands:

$EXPDP Username/password,

Common commands for interactive mode:

Continue_client returns to record mode. If it is idle, the job will be restarted.

Start_job initiates the recovery of the current job.

Status at the default value (0) Displays the job status of the frequency (in seconds) to be monitored when the new state is available.

Status=[interval]

Stop_job closes the executed job and exits the client.

The stop_job=immediate will immediately close the data pump job.

There are other commands:

Add_file adds a dump file to the dump file set.

Add_file=dirobjdumpfile-name

Continue_client returns to record mode. If it is idle, the job will be restarted.

Exit_client exits the client session and puts the job in a running state.

Help summarizes the interactive commands.

Kill_job Detach and delete jobs.

Parallel changes the number of active workers for the current job.

The number of Parallel=worker.

Start_job initiates the recovery of the current job.

Status at the default value (0) will display when the new state is available,

The job status of the frequency (in seconds) to monitor.

Status=[interval]

Stop_job closes the executed job and exits the client.

Stop_job=immediate will close immediately

[Note]--oracle method to terminate the EXPDP/IMPDP process run