expdp 수행 중 중단 ORA-31634: job already exists

 

Export: Release 10.2.0.4.0 - 64bit Production on Wednesday, 30 January, 2013 15:36:41 Copyright (c) 2003, 2007, Oracle.  All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options ORA-31634: job already exists ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.KUPV$FT", line 867 ORA-31637: cannot create job MANUAL_JOB for user MIGADMIN

 

select * from dba_datapump_jobs;

에서 state가 EXECUTING 인 JOB_NAME을 선택 <-- MANUAL_JOB

 

drop table MANUAL_JOB purge;