IMPDP hangs – wait for unread message on broadcast channelPosted: October 1, 2008
If IMPDP hangs, and if checking in v$sessionwait shows it is waiting on “wait for unread message on broadcast channel”, check the alert log. You may see something like:
statement in resumable session ‘SYSTEM.SCHEMAIMPORT.1’ was suspended due to
ORA-01658: unable to create INITIAL extent for segment in tablespace TESTDATA
Now you know what to do.
So simple, but somehow googling for IMPDP and “wait for unread message on broadcast channel” doesn’t come up with much information. Hopefully, now the search results will contain one more helpful suggestion.