데이타펌프진행상태조회

select * from dba_datapump_jobs ; --진행상태조회 select sid, serial#, sofar, totalwork, to_char(start_time, 'HH24:MI:SS') startt, (sofar/totalwork)*100 "complete(%)" from v$session_longops where opname='META' and sofar != totalwork ; SQL> select sid, serial#, opname, 2 to_char(start_time, 'HH24:MI:SS') startt, 3 (sofar/totalwork)*100 "complete(%)" 4 from v$session_longops 5 where totalwork > 0 ; 위의 정보..

원문링크 : 데이타펌프진행상태조회