Thursday, February 23, 2012

Restarting an IMPDP Job

There is a unique feature in impdp by which we could re-start the job, from the exact position where it stopped.

The reason for the job getting stopped(or forcefully stopped) could be anything from lack of space or if in case of any database parameter change.

The steps are as below :

1. In the import window - Ctrl -C(to come out of the running job)
2. Import> stop_job=immediate
3. Do the necessary changes.
4. Find the job name (SELECT * FROM DBA_DATAPUMP_JOBS;)
5. Attach to the job - impdp system/xxxxxxxxxxx attach=SYS_IMPORT_FULL_01
6. Restart the job
Import> start_job
7. Check the status
Import> status