Hi all,

You can find status of impdp that executing with these queries:

#1

SELECT
    * 
FROM
    DBA_DATAPUMP_JOBS 
WHERE
    1 = 1 AND STATE = 'EXECUTING';

#2

SELECT
    SID, SERIAL#, SOFAR, TOTALWORK, DP.OWNER_NAME, DP.STATE, DP.JOB_MODE 
FROM
    GV$SESSION_LONGOPS SL, GV$DATAPUMP_JOB DP 
WHERE
    1 = 1 AND SL.OPNAME = DP.JOB_NAME AND SOFAR != TOTALWORK;

#3

SELECT
    SID, SERIAL#, OPNAME, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) COMPLETE 
FROM
    V$SESSION_LONGOPS 
WHERE
    1 = 1 AND TOTALWORK != 0 AND SOFAR != TOTALWORK 
ORDER BY
    1;

#4

SELECT
    X.JOB_NAME, B.STATE, B.JOB_MODE, B.DEGREE, X.OWNER_NAME, Z.SQL_TEXT, P.MESSAGE, P.TOTALWORK, P.SOFAR, ROUND((P.SOFAR/P.TOTALWORK)*100,2) DONE, P.TIME_REMAINING
FROM
    DBA_DATAPUMP_JOBS B LEFT JOIN DBA_DATAPUMP_SESSIONS X ON (X.JOB_NAME = B.JOB_NAME) LEFT JOIN V$SESSION Y ON (Y.SADDR = X.SADDR) LEFT JOIN V$SQL Z ON (Y.SQL_ID = Z.SQL_ID) LEFT JOIN V$SESSION_LONGOPS P ON (P.SQL_ID = Y.SQL_ID)
WHERE
    1 = 1 AND Y.MODULE = 'Data Pump Worker' AND P.TIME_REMAINING > 0;

See you later.