Page Banner

oracle impdp as sysdba and attach job

impdp allows Oracle DBA to exit out of the current process while the job continues to run in the background.  In the event you have to connect to the job and take some action, below is how that can be accomplished:

In the following example job name is – “my_job”


impdp \"/as sysdba\" attach=my_job

Once you attach to the job, impdp utility will display the current status of the job. impdp job can be killed using the following command:

Import> kill_job
Are you sure you wish to stop this job ([yes]/no): yes