RDBMS 11.2.0.4
方法1
expdp \"/as sysdba\" attach=SYS_EXPORT_SCHEMA_01 ,再使用status查看 (略)
方法2 使用status参数,单位是秒。多少秒更新一次状态
[oracle@test02 ~]$ expdp \"/ as sysdba\" status=1
Export: Release 11.2.0.4.0 - Production on Tue Mar 13 10:45:11 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
State: UNDEFINED
Starting "SYS"."SYS_EXPORT_SCHEMA_01": "/******** AS SYSDBA" status=1
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Estimate in progress using BLOCKS method...
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Total estimation using BLOCKS method: 0 KB
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 8,192
Worker 1 Status:
Process Name: DW00
State: WORK WAITING
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 1
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 8,192
Worker 1 Status:
Process Name: DW00
State: WORK WAITING
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 1
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 8,192
Worker 1 Status:
Process Name: DW00
State: WORK WAITING
******************************************************************************
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: COMPLETING
Bytes Processed: 1
Percent Done: 100
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 8,192
Worker 1 Status:
Process Name: DW00
State: WORK WAITING
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: COMPLETING
Bytes Processed: 1
Percent Done: 100
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 8,192
Worker 1 Status:
Process Name: DW00
State: WORK WAITING
/u01/app/oracle/admin/orcl/dpdump/expdat.dmp
Job: SYS_EXPORT_SCHEMA_01
Operation: EXPORT
Mode: SCHEMA
State: COMPLETED
Bytes Processed: 1
Percent Done: 100
Current Parallelism: 1
Job Error Count: 0
Dump File: /u01/app/oracle/admin/orcl/dpdump/expdat.dmp
bytes written: 8,192
Worker 1 Status:
Process Name: DW00
State: WORK WAITING
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Mar 13 10:45:24 2018 elapsed 0 00:00:13
数据泵job的其他操作,expdp \"/as sysdba\" attach=SYS_EXPORT_SCHEMA_01 后,看帮助 (略)
END