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.