Alert log:
=======
kupprdp: master process DM00 started with pid=42, OS id=7353
to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_TABLE_01', 'S2', 'KUPC$C_1_20160821122303', 'KUPC$S_1_20160821122303', 0);
kupprdp: worker process DW01 started with worker id=1, pid=25, OS id=7355
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_TABLE_01', 'S2');
Solutions.
========
solution
SQL> select job_name,state from dba_datapump_jobs;
JOB_NAME STATE
—————————— ——————————
SYS_EXPORT_FULL_02 EXECUTING
SYS_EXPORT_FULL_01 NOT RUNNING
correction on my instruction above:
– just take note on job_name and owner value.
– in SQLPlus execute DBMS_DATAPUMP.STOP_JOB as follows:
exec DBMS_DATAPUMP.STOP_JOB (DBMS_DATAPUMP.ATTACH(‘JOB_NAME’,’OWNER’,1.0)
– ‘1’ is to abort the job immediately
– ‘0’ is to remove the job from the job list so that it is not restartable
SQL> exec DBMS_DATAPUMP.STOP_JOB (DBMS_DATAPUMP.ATTACH(‘SYS_EXPORT_SCHEMA_01′,’SYSTEM’),1,0);
No comments:
Post a Comment