ORA-62142
MEMOPTIMIZE FOR READ feature requires NOT DEFERRABLE PRIMARY KEY constraint on the table
Cause
An attempt was made to use MEMOPTIMIZE FOR READ on a table that did not have the PRIMARY KEY constraint or the PRIMARY KEY constraint is DEFERRABLE.
Action
None