Oracle Error ORA-14664: Cannot use PL/SQL expressions in reference partitioning parent key

Oracle Error Message

ORA-14664: Cannot use PL/SQL expressions in reference partitioning parent key

Reason for the Error

Parent key of the reference partitioned table’s partitioning constraint contained a virtual column that referenced a PL/SQL expression.

Solution

Correct the statement to specify a partitioning constraint with supported parent key and reenter.