ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.

ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.


Cause:


An attempt was made to select FOR UPDATE from a view which had not been merged because the view used syntax (for example, DISTINCT or GROUP BY) preventing the merge, or because of initialization file parameter settings.



Action:


Determine the reason the view will not merge and, if possible, make changes so that it can.