CHECK EXPORT JOB is SUCCESSFULL or NOT

CHECK EXPORT JOB is SUCCESSFULL or NOT


sqlplus / as sysdba

select * from dba_datapump_jobs;

note the jobname(SYS_EXPORT_FULL_01, SYS_EXPORT_SCHEMA_01, SYS_EXPORT_TABLE_01)


To check the KILLED,PAUSED,STOPED  JOBS

select * from dba_datapump_jobs



To check the SUCCESSFUL JOBS

select opname,target_desc,start_time,elapsed_seconds,message from v$session_longops where OPNAME='SYS_EXPORT_FULL_01' order by start_time desc;