Database Reference
In-Depth Information
You can press Ctrl+C for either an export or an import job. For an import job the interactive command mode
prompt is
Import>
To view all commands available, type
HELP
:
Import> help
The interactive command mode import commands are summarized in Table
8-2
.
Table 8-2.
Import Interactive Commands
Command
Description
CONTINUE_CLIENT
Continues with interactive logging mode
EXIT_CLIENT
Exits the client session and returns to the OS prompt. Leaves the current job running
HELP
Displays the available interactive commands
KILL_JOB
Terminates the job currently connected to in the client
PARALLEL
Increases or decreases the degree of parallelism
START_JOB
Restarts a previously stopped job.
START_JOB=SKIP_CURRENT
restarts the job and skips
any operations that were active when the job was stopped
STATUS
Specifies the frequency at which the job status is monitored. Default mode is 0; the
client reports job status changes whenever available in this mode.
STOP_JOB [=IMMEDIATE]
Stops a job from processing (you can later restart it). Using the
IMMEDIATE
parameter
quickly stops the job, but there may be some incomplete tasks.
Type
EXIT
to leave the Data Pump status utility:
Import> exit
You should now be at the OS prompt.
Attaching to a Running Job
One powerful feature of Data Pump is that you can attach to a currently running job and view its progress and status.
If you have DBA privileges, you can even attach to a job if you aren't the owner. You can attach to either an import or
an export job via the
ATTACH
parameter.
Before you attach to a job, you must first determine the Data Pump job name (and owner name, if you're not the
owner of the job). Run the following SQL query to display currently running jobs:
SQL> select owner_name, operation, job_name, state from dba_datapump_jobs;
Here is some sample output:
OWNER_NAME OPERATION JOB_NAME STATE
---------- --------------- -------------------- --------------------
MV_MAINT EXPORT SYS_EXPORT_SCHEMA_01 EXECUTING
