Thursday, January 26, 2012

check datapump jobs

1. find job name
select * from user_datapump_jobs;
select * from dba_datapump_sessions;

2. login to datapump and attache the job
impdp attach=[schema].job_name

ATTEN: don't user hyphen - in you job name. You may not be able to attach to a job have hyphen in its name.
3.
impdp> status



reference:
http://peerdba.wordpress.com/2011/01/13/killing-expdpimpdp-job/

No comments:

Post a Comment