Oracle Error ORA-39806: The attempt to lock string parent table string string string failed.

Oracle Error Message

ORA-39806: The attempt to lock string parent table string string string failed.

Reason for the Error

While loading the child table of a partitioning referential constraint, the parent table must be locked in SHARE mode.

Solution

Determine why the parent table could not be locked and retry.