Datapump

[exp.par]
dumpfile=expSet1_%U.dmp, expSet2_%U.dmp
job_name=EXPORT_TEMPORANEO
directory=EXP_DIR
logfile=exp.log
schemas=DIMENSION
status=60
version=LATEST
parallel=2
filesize=10G

create directory EXP_DIR as '/u02/dpdata1';
--grant read, write on directory dpdata1 to expdb;

nohup expdp system/manager parfile=exp.par &
impdp ananda/abc123 directory=dpdata1 dumpfile=expCASES.dmp job_name=cases_import

DBA_DATAPUMP_JOBS - DBA_DATAPUMP_SESSIONS

Killing datapump
select s.sid, 'kill -9 ' || spid, s.program, s.terminal, machine, osuser, type, module 
from v$process p, v$session s
where s.paddr = p.addr
and action = 'EXPORT_TEMPORANEO'

drop table EXPORT_TEMPORANEO