"DB written interview 164" in Oracle, how do I stop the EXPDP data pump process completely?

real question 1,how to stop completelyEXPDPprocess?

answer: Many colleagues are using command, accidentally pressed ctrl+c key combinations, Then enter exit EXPDP

1 , check EXPDP whether the process is still

Ps-ef | grep EXPDP

kill-9 process "command to kill EXPDP

2 , check if the session still exists, Kill the associated session if it exists (note: Use the command " os level use kill-9 kill the process), such as the No-kill session permissions can be related to the table drop drop, the table name can be used as follows sql to query:

SELECT * from Dba_datapump_sessions;

SELECT * from Dba_datapump_jobs;

For example:

[email protected] > SELECT * from Dba_datapump_sessions;

Owner_name job_name inst_id saddr session_type

---------- ------------------------- ---------- ---------------- --------------

LHR sys_export_schema_04 1 00000000a8b71d98 MASTER

LHR sys_export_schema_04 1 00000000ab98afc8 WORKER

[email protected] > DROP TABLE LHR. Sys_export_schema_04 PURGE;

Table dropped.

[email protected] > SELECT * from Dba_datapump_sessions;

No rows selected

[email protected] > SELECT * from Dba_datapump_jobs;

No rows selected

use the same method also delete from view Dba_datapump_jobs The tables are queried until the two views are not recorded.

3 dmp file. If not removed, the EXPDP command will be reported dmp file already exists error.

here the author gives a common SQL statement, you can query EXPDP For more information about the related sessions, as follows:

--------------------------- how to stop completely EXPDP process?

SET Line 9999

COL owner_name for A10

COL job_name for A25

COL Operation for A10

COL Job_mode for A10

COL State for A15

COL Osuser for A10

COL "degree| attached| DataPump "for A25

COL Session_info for A20

SELECT DS. INST_ID,

Dj. Owner_name,

Dj. Job_name,

TRIM (DJ. Operation) operation,

TRIM (DJ. Job_mode) Job_mode,

Dj. State,

Dj. degree | | ',' || Dj. attached_sessions | | ',' || Dj. Datapump_sessions "degree| attached| DataPump ",

Ds. Session_type,

S.osuser,

(SELECT S.sid | | ',' || s.serial# | | ',' || P.spid

From Gv$process P

WHERE s.paddr = p.addr

and s.inst_id = p.inst_id) session_info

From Dba_datapump_jobs DJ--gv$datapump_job

Full OUTER JOIN dba_datapump_sessions DS--gv$datapump_session

On (DJ. Job_name = DS. Job_name and DJ. Owner_name = DS. owner_name)

Left OUTER JOIN gv$session S

On (s.saddr = DS. Saddr and DS. inst_id = s.inst_id)

ORDER by DJ. Owner_name, DJ. Job_name;

SELECT * from Gv$datapump_session;

SELECT * from Gv$datapump_jobs;

SELECT * from Dba_datapump_jobs;

"DB written interview 164" in Oracle, how do I stop the EXPDP data pump process completely?