oracle查看expdp进度,监控EXPDP/IMPDP进度

--获取JOB_NAME

select * from DBA_DATAPUMP_JOBS;

OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS

-------------------- ------------------------------ -------------------- -------------------- ------------------------------ ---------- ----------------- -----------------

SYSTEM SYS_IMPORT_SCHEMA_01 IMPORT SCHEMA EXECUTING 1 0 2

1 row selected.

--使用attach参数

impdp system/*** attach=SYS_IMPORT_SCHEMA_01

expdp system/*** attach=SYS_IMPORT_SCHEMA_01

[oracle@test ~]$ impdp system/qwer1234 attach=SYS_IMPORT_SCHEMA_01

Import: Release 11.2.0.4.0 - Production on Thu Jan 3 15:19:42 2019

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 Re