1.查看视图dba_datapump_jobs

SQL> set line 200

SQL> select job_name,state from dba_datapump_jobs;

JOB_NAME                                                     STATE

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

EXPDP4                                                       EXECUTING

SQL>

2.登陆expdp

[oracle@bddjpt ~]$ expdp bddj2user/bddj2user123 attach=EXPDP4

Worker 1 Status:

  Process Name: DW00

  State: EXECUTING

  Object Schema: BDDJ2USER

  Object Name: PRIP_LCCONT

  Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA

  Completed Objects: 3

  Total Objects: 132

  Worker Parallelism: 1

Export>

注：[oracle@bddjpt dpdump]$expdp  bddj2user/bddj2user123 DIRECTORY=PUMP_DIR DUMPFILE=bddj2user_%U.dmp logfile=bddj2user.log filesize=30G job_name=expdp4

3.停掉expdp

Export> stop_job=immediate

Are you sure you wish to stop this job ([yes]/no): yes

4.清理job

http://www.cnblogs.com/polestar/p/6677355.html