Oracle Database 12c New Features

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

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


Cause:


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



Action:


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