expdp导出工具可以实现在导出任务执行过程中修改并行度、终止、监控任务功能。
做实验验证一下：
[oracle@test dpdump]$ expdp system/password directory=DATA_PUMP_DIR dumpfile=alphaFull full=y job_name=alphaFull Export: Release 11.2.0.3. - Production on Fri Dec :: Copyright (c) , , Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3. - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."ALPHAFULL": system/******** directory=DATA_PUMP_DIR dumpfile=alphaFull full=y job_name=alphaFull
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 76.37 MB
Processing object type DATABASE_EXPORT/TABLESPACE
…… ……
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
^C
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> CONTINUE_CLIENT
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION
Job "SYSTEM"."ALPHAFULL" stopped by user request at 17:05:26
另打开一个terminal：这里指定attach参数为刚才的job_name参数
[oracle@test ~]$ expdp system/password attach=alphaFull Export: Release 11.2.0.3. - Production on Fri Dec :: Copyright (c) , , Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3. - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options Job: ALPHAFULL
Owner: SYSTEM
Operation: EXPORT
Creator Privs: TRUE
GUID: EDF48D67526907E6E043646EA8C00CB2
Start Time: Friday, December, ::
Mode: FULL
Instance: orcl
Max Parallelism:
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND system/******** directory=DATA_PUMP_DIR dumpfile=alphaFull full=y job_name=alphaFull
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /s01/app/oracle/admin/orcl/dpdump/alphaFull.dmp
bytes written: 4,096 Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: SYSMAN
Object Name: AQ$_MGMT_LOADER_QTABLE_N
Object Type: DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Completed Objects: 51
Total Objects: 51
Worker Parallelism: 1 Export> STOP_JOB
Are you sure you wish to stop this job ([yes]/no): yes
在这里STOP_JOB之后，在任务执行的session可以看到
Job "SYSTEM"."ALPHAFULL" stopped by user request at 17:05:26