Database Reference
In-Depth Information
In this example the
MV_MAINT
user can directly attach to the export job, as shown:
$ expdp mv_maint/foo attach=sys_export_schema_01
If you aren't the owner of the job, you attach to the job by specifying the owner name and the job name:
$ expdp system/foobar attach=mv_maint.sys_export_schema_01
You should now see the Data Pump command-line prompt:
Export>
Type
STATUS
to view the status of the currently attached job:
Export> status
Stopping and Restarting a Job
If you have a currently running Data Pump job that you want to temporarily stop, you can do so by first attaching to
the interactive command mode. You may want to stop a job to resolve space issues or performance issues and then,
after resolving the issues, restart the job. This example attaches to an import job:
$ impdp mv_maint/foo attach=sys_import_table_01
Now, stop the job, using the
STOP_JOB
parameter:
Import> stop_job
You should see this output:
Are you sure you wish to stop this job ([yes]/no):
Type
YES
to proceed with stopping the job. You can also specify that the job be stopped immediately:
Import> stop_job=immediate
When you stop a job with the
IMMEDIATE
option, there may be some incomplete tasks associated with the job. To
restart a job, attach to interactive command mode, and issue the
START_JOB
command:
Import> start_job
If you want to resume logging job output to your terminal, issue the
CONTINUE_CLIENT
command:
Import> continue_client
