Data Pump (expdp, impdp) Interactive Command Mode

itoporacledbaadmin | 22nd February 2017

Interactive Command Mode (CTRL+C)

When running the expdp or impdp utilities the log output is also shown on the screen, but I can stop this and switch to the interactive mode by issuing CTRL+C.

Once in the interactive mode, we have access to a number of commands described here (expdp, impdp). There are some differences between the commands available for each utility(command help in expdp prompt as below)

expdp suphisara/xxxxxxx directory=EXP_DIR dumpfile=db11g_full.dmp logfile=db11g_full.log full=y

[oracle@labdbT1 ~]$ sqlplus “/as sysdba”

SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 22 23:12:18 2012

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL>
SQL> select * from dba_datapump_jobs;

OWNER_NAME JOB_NAME
—————————— ——————————
OPERATION
——————————————————————————–
JOB_MODE
——————————————————————————–
STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
—————————— ———- —————– —————–
SUPHISARA SYS_EXPORT_FULL_01
EXPORT
FULL
EXECUTING 1 1 3

SQL> !
[oracle@labdbT1 ~]$ expdp suphisara/xxxxxxx attach=SYS_EXPORT_FULL_01

Export: Release 11.2.0.1.0 – Production on Fri Feb 22 23:13:20 2012

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Job: SYS_EXPORT_FULL_01
Owner: SUPHISARA
Operation: EXPORT
Creator Privs: TRUE
GUID: 827ED9BD0C4EC26FE050A8C0814B7498
Start Time: Friday, 22 February, 2012 23:12:05
Mode: FULL
Instance: DB11G
Max Parallelism: 1
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND suphisara/******** directory=EXP_DIR dumpfile=db11g_full.dmp logfile=db11g_full.log full=y
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /home/oracle/exp_dir/db11g_full.dmp
bytes written: 4,096

Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: APEX_030200
Object Type: DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT
Completed Objects: 3
Worker Parallelism: 1

Export> help
——————————————————————————

The following commands are valid while in interactive mode.
Note: abbreviations are allowed.

ADD_FILE
Add dumpfile to dumpfile set.

CONTINUE_CLIENT
Return to logging mode. Job will be restarted if idle.

EXIT_CLIENT
Quit client session and leave job running.

FILESIZE
Default filesize (bytes) for subsequent ADD_FILE commands.

HELP
Summarize interactive commands.

KILL_JOB
Detach and delete job.

PARALLEL
Change the number of active workers for current job.

REUSE_DUMPFILES
Overwrite destination dump file if it exists [N].

START_JOB
Start or resume current job.
Valid keyword values are: SKIP_CURRENT.

STATUS
Frequency (secs) job status is to be monitored where
the default [0] will show new status when available.

STOP_JOB
Orderly shutdown of job execution and exits the client.
Valid keyword values are: IMMEDIATE.

Export> status

Job: SYS_EXPORT_FULL_01
Operation: EXPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /home/oracle/exp_dir/db11g_full.dmp
bytes written: 4,096

Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: SYSMAN
Object Name: MGMT_PARAM_CRED_TGT_MET_ARR
Object Type: DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Completed Objects: 722
Total Objects: 722
Worker Parallelism: 1

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

Note

The following command “help” then, you can see the commands are valid while in interactive mode, you can choose that, depending on your task.

3,812

I'm Top Oracle DBA