Oracle Error ORA-14666: Cannot use expressions involving BLOB or CLOB data types in reference partitioning parent key

Oracle Error Message

ORA-14666: Cannot use expressions involving BLOB or CLOB data types in reference partitioning parent key

Reason for the Error

Parent key of the reference partitioned table’s partitioning constraint contained a virtual column that involved a BLOB or CLOB data type.

Solution

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