4 Replies Latest reply: Apr 13, 2012 10:18 AM by Dom Brooks RSS

    Impact of solution of ORA-00979: not a GROUP BY expression in Oracle11g R2


      We have a query which is working in 10g and giving error "ORA-00979: not a GROUP BY expression" in Oracle11g R2 ( we have found following two solution to resolve it from the internet.

      1)You can Set the hidden parameter “_FIX_CONTROL”=’5520732:OFF’ in the pfile. This parameter disables a given bug number.

      2)We can set the parameter optimizer_features_enable to a previous version of Oracle, ’′

      but I am unable to find the side effects of above change, so I need to know:
      1)whcih is batter solution
      2)what are the possible side effects of both solution.