In the alert log we find this error while taking export.

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.
========

Step1: Check the job name with schema

Step 2: To stop the job perform below steps

Syntax

exec DBMS_DATAPUMP.STOP_JOB (DBMS_DATAPUMP.ATTACH(‘JOB_NAME’,’OWNER’,1.0)

  1. ‘1’ is to abort the job immediately
  2. ‘0’ is to remove the job from the job list so that it is not restartable

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Anuradha’s LinkedIn: https://www.linkedin.com/in/dbaanuradhamudgal/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply