Database Utilities (MOSC)

MOSC Banner

impdp inactive for hours

edited Aug 6, 2014 2:42AM in Database Utilities (MOSC) 2 commentsAnswered ✓

Hi all,

on 11.2.0.4

I ran the following command line

impdp system/*****@orcl FULL=Y DUMPFILE=EXP_FUL_ORCL.DMP

but seems hunging since several hours ego. Nothing added to alertlog. The last line in it is :

Replication after-import: constraint REPCAT$_SITES_NEW_FK2 for "SYSTEM"."REPCAT$_SITES_NEW" is enabled successfully

And in v$session :

select module ,status, sql_id, event, seconds_in_wait from v$session where program='impdp.exe'

MODULE                                                     STATUS   SQL_ID  EVENT                                                      SECONDS_IN_WAIT                 

---------------------------------------------------------------- -------- ------------- ---------------------------------------------------------------- ---------------------------------------

impdp.exe                                                  INACTIVE 8c0syt8yv0qvn SQL*Net message from client                                3499                            

1 rows selected

select BLOCKING_INSTANCE, BLOCKING_SESSION from v$session where program='impdp.exe'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center