Database Reference
In-Depth Information
Entering Interactive Command Mode
There are two ways to access the interactive command mode prompt:
expdp
or
impdp
.
•
Press Ctrl+C in a Data Pump job that you started via
ATTACH
parameter to attach to a currently running job.
•
Use the
When you run a Data Pump job from the command line, you're placed in the command-line mode. You should
see output displayed to your terminal as a job progresses. If you want to exit command-line mode, press Ctrl+C.
This places you in the interactive command-interface mode. For an export job, the prompt is
Export>
Type in the
HELP
command to view the export interactive commands available (see Table
8-1
):
Export> help
Table 8-1.
Export Interactive Commands
Command
Description
ADD_FILE
Adds files to the export dump set
CONTINUE_CLIENT
Continues with interactive client mode
EXIT_CLIENT
Exits the client session and returns to the OS prompt; leaves the current job running
FILESIZE
Defines file size for any subsequently created dump files
HELP
Displays interactive export commands
KILL_JOB
Terminates the current job
PARALLEL
Increases or decreases the degree of parallelism
REUSE_DUMPFILES
Overwrites the dump file if it exists (default is
N
)
START_JOB
Restarts the attached job
STATUS
Displays the status of the currently attached job
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 interactive command mode:
Export> exit
You should now be at the OS prompt.
