Oracle DBA, How To, Error, Cause and Action

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.