1.查看视图dba_datapump_jobsSQL> set line 200SQL> select job_name,state from dba_datapump_jobs;JOB_NAME STATE------------------------------------------------------------ ------------------------------------------------------------EXPDP4 EXECUTINGSQL>2.登陆expdp[oracle@bddjpt ~]$ expdp bddj2user/bddj2user123 attach=EXPDP4Worker 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: 1Export> 注:[oracle@bddjpt dpdump]$expdp bddj2user/bddj2user123 DIRECTORY=PUMP_DIR DUMPFILE=bddj2user_%U.dmp logfile=bddj2user.log filesize=30G job_name=expdp43.停掉expdpExport> stop_job=immediate Are you sure you wish to stop this job ([yes]/no): yes4.清理jobhttp://www.cnblogs.com/polestar/p/6677355.html