Oracle 10.2.0.1 onwards
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
2. Press CTL+C following screen will appear.
Now type “stop_job=immediate”
3. 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.