Oracle Error ORA-39808: The SINGLEROW option must be specified for parent table string.

Oracle Error Message

ORA-39808: The SINGLEROW option must be specified for parent table string.

Reason for the Error

The SINGLEROW option was not specified when loading both the parent and child table of a partitioning referential constraint.

Solution

Ensure the SINGLEROW option is specified for the parent when loading the parent and child of a partitioning referential constraint.