Expdp background View
Today, after executing the data import command expdp, we found that there was less than one parameter. Press CTRL + C. Who can perform this operation only on the surface of cancel? In fact, the background is still running.
system/******** schemas=CEN_DEV_OWNER20130506,CEN_DEV_USER20130506 directory=exp_dir dumpfile=expdp_cen052701.dmp,expdp_cen052702.dmp,expdp_cen052703.dmp,expdp_cen052704.dmp,expdp_cen052705.dmp logfile=expdp_cen0527.log parallel=5
How can we find out and actually stop this task? After checking some information, perform the following operations:
The two queries are used to determine the dump job name: select * from DBA_DATAPUMP_JOBS; select * from DBA_DATAPUMP_SESSIONS; SQL> select * from DBA_DATAPUMP_SESSIONS; OWNER_NAME JOB_NAME INST_ID SADDR SESSION_TYPE --------------- certificate ---------- -------------- SYSTEM quota 1 000000097472AE68 MASTERSYSTEM quota 1 000000095079A4E8 WORKER enter the expdp interactive interface: C: \ Users \ Administrator> expdp system/cenorcl attach = SYS_EXPORT_SCHEMA_01Export> helpExport> kill_jobAre you sure you wish to stop this job ([yes]/no): yes
This completely ends the task.