QUICKIE
=======
create or replace directory HAJO_DUMPDIR as '/tmp';

grant read, write on directory HAJO_DUMPDIR to hajo;

expdp hajo/hajo tables=hajo1.testtable directory=HAJO_DUMPDIR dumpfile=expdp_hajo1_testtable.dmp logfile=expdp_hajo1_testtable.log
impdp hajo/hajo directory=HAJO_DUMPDIR dumpfile=expdp_hajo1_testtable.dmp logfile=impdp_hajo1_testtable.log REMAP_SCHEMA=hajo1:hajo2 DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS

drop directory HAJO_DUMPDIR as '/tmp';
drop table hajo2.testtable;
_____________________________________________________________________________________________________________________________
_____________________________________________________________________________________________________________________________

col owner_name for a10
col job_name for a20
col operation for a10
col job_mode for a10
col state for a10
select owner_name, job_name, operation, job_mode, state, degree, attached_sessions, datapump_sessions from dba_datapump_jobs;

OWNER_NAME JOB_NAME             OPERATION  JOB_MODE   STATE          DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
---------- -------------------- ---------- ---------- ---------- ---------- ----------------- -----------------
APP_DBA    SYS_IMPORT_FULL_01   IMPORT     FULL       EXECUTING           4                 1                 3



impdp user/pw attach=SYS_IMPORT_FULL_01

Import> KILL_JOB
Möchten Sie diesen Job wirklich stoppen ([yes]/no): yes
_____________________________________________________________________________________________________________________________
_____________________________________________________________________________________________________________________________

CLEANUP ORPHANED DATA PUMP JOBS
===============================

ORPHANED JOBS ARE IN STATE "NOT RUNNING"!
ORPHANED JOBS ARE IN STATE "NOT RUNNING"!
ORPHANED JOBS ARE IN STATE "NOT RUNNING"!

select owner_name, job_name, operation, job_mode, state, degree, attached_sessions, datapump_sessions from dba_datapump_jobs;

OWNER_NAME JOB_NAME             OPERATION  JOB_MODE   STATE            DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
---------- -------------------- ---------- ---------- -----------  ---------- ----------------- -----------------
APP_DBA    SYS_IMPORT_FULL_01   IMPORT     FULL       NOT RUNNING           4                 1                 3


JUST DROP THE MASTER TABLE (AND PURGE IT FROM RECYCLE BIN IF THIS DOESN'T HELP):
................................................................................
drop table APP_DBA.SYS_IMPORT_FULL_01;

purge table APP_DBA.SYS_IMPORT_FULL_01;
_____________________________________________________________________________________________________________________________