col comments format a100
select * from dict where table_name like '%DATAPUMP%';
TABLE_NAME COMMENTS
------------------------- ----------------------------------------------------------------------------------------------------
DBA_DATAPUMP_JOBS Datapump jobs
DBA_DATAPUMP_SESSIONS Datapump sessions attached to a job
USER_DATAPUMP_JOBS Datapump jobs for current user
V$DATAPUMP_JOB Synonym for V_$DATAPUMP_JOB
V$DATAPUMP_SESSION Synonym for V_$DATAPUMP_SESSION
GV$DATAPUMP_JOB Synonym for GV_$DATAPUMP_JOB
GV$DATAPUMP_SESSION Synonym for GV_$DATAPUMP_SESSION
问:能否查询数据泵的执行情况吗?例如哪个用户、何几时执行的。
答:似乎不能。
系统层面
history | grep -i expdp