Oracle Data Pump Detailed (5) command interaction mode

After we have a datapump job, we can view the current progress through v$session_longops.

Username-job owner    
opname-job name    
target_desc-job operation    
Sofar-megabytes transferred thus far Duri ng the job totalwork-estimated number of megabytes in the    
job    
units-megabytes (MB)    
message-a formatted s Tatus message of the form:    
' job_name:operation_name:nnn out of mmm MB done '

Sys@test16>select username,opname,sofar,totalwork,units,message from V$session_longops 

where Opname= ' SYS_ Export_full_03 ';  
      
USERNAME        opname                    sofar  totalwork UNITS message  
---------------------------------------------- --------------------------------------

------------------------------------  
SYSTEM          Sys_export_ full_03         4737      35368 mb    sys_export_full_03: 

export:4737 out of 35368 MB done

But sometimes monitoring alone is not enough, we may need to modify the corresponding job, then we need to Datapumo mode of command interaction.

There are two ways to enter the command interaction mode, respectively:

1. Press CTRL + C in logging mode

2. EXPDP or IMPDP Attach=system. Sys_export_full_03

The commands for the EXPDP interactive mode are as follows:

activity	command Used
add tional dump files.	add_fi LE
exit interactive mode and enter logging mode.	contin ue_client
stop the export client session, but leave the job running.	exit_c lient
redefine the default size to is used for any subsequent dump files.	filesi ZE
display a summary of available commands.	help
detach all currently attached client sessions and terminate the current job .	kill_j OB
increase or decrease the number of active worker processes for the current job. This command is valid Enterprise Edition of Oracle Database 11g.	parall EL
restart a stopped job to which for you are attached.	start_ JOB
display detailed status for the current job and/or set status interval.	status
stop the current job for later restart.	stop_j OB

The interactive mode commands for IMPDP are as follows:

activity	command Used
exit interactive-command mode.	contin ue_client
stop the import client session, but leave the current job running.	exit_c lient
display a summary of available commands.	help
detach all currently attached client sessions and Termin Ate the current job.	kill_j OB
increase or Decrease the NUmber of active worker processes for the current job. This command are valid only in Oracle Database Enterprise Edition.	parall EL
restart a stopped job to which for you are attached.	start_ JOB
display detailed status for the current job.	status
stop the current job.	stop_j OB