How to stop Expdp and Impdp job


Expdp and Impdp job is running suddenly need to stop this job. Use following job:

  1. Go to screen when job is running like

[oracle@itc266 ~]$ impdp system/sys dumpfile=test.dmp directory=backup logfile=test.log

Import: Release 10.2.0.1.0 – Production on Monday, 11 July, 2011 13:43:22

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production

With the Partitioning, OLAP and Data Mining options

Master table “SYSTEM”.”SYS_IMPORT_FULL_08″ successfully loaded/unloaded

Starting “SYSTEM”.”SYS_IMPORT_FULL_08″:  system/******** dumpfile=test.dmp directory=backup logfile=test.log  Processing object type SCHEMA_EXPORT/USER

ORA-31684: Object type USER:”tst” already exists

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM

  1. Press CTL+C following screen will appear.

Import>

Now type “stop_job=immediate”

Import> stop_job=immediate

  1. Following screen will appear:

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

Now type “yes”

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

Expdp or Impdp will stop after few seconds.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s