Oracle Database 12c New Features

ORA-14657: cannot cascade row migration to reference-partitioned child table

ORA-14657: cannot cascade row migration to reference-partitioned child table


Cause:


Update of a parent key may require migration of rows in reference-partitioned child tables, however this is not supported because the parent key was not suitably indexed.



Action:


Replace the existing index on the parent key with a unique index that does not contain any columns in addition to the parent key.