ORA-04020: deadlock detected while trying to lock object GET_MESSAGE_TYPE During IMPDP
Hi,
IMPDP is getting hanged when it reaches to processing packages stage,
IMPDP DIRECTORY=DATA_PUMP_DIR DUMPFILE=ADPPRD_28.DMP LOGFILE=ADPPRD_28.LOG
Trace File
------------------------------------
*** 2018-12-12 19:02:46.365
A deadlock among DDL and parse locks is detected.
This deadlock is usually due to user errors in
the design of an application or from issuing a set
of concurrent statements which can cause a deadlock.
This should not be reported to Oracle Support.
The following information may aid in finding
the errors which cause the deadlock:
ORA-04020: deadlock detected while trying to lock object HR_BASE.GET_MESSAGE_TYPE
--------------------------------------------------------
object waiting waiting blocking blocking