Hi to all
I have several View object in oracle 220.127.116.11 and they worked fine. After doing a full import into Oracle 18.104.22.168, these views objects encountered "ORA-00979: not a GROUP BY expression". Tried recompiling all dependencies successfully but these views just couldn't do likewise.
I have refer to Oracle document ID 814423.1 and 8260094. I have tried the workaround as suggested:
1. Set replacevirtual_columns to false.
2. If the same problem still reports then, Set optimizergroup_by_placement to false instead of replacevirtual_columns.
However, these views are still having the error. Does anybody know what's the next step for me?
I can post the View scripts here, but there are several of them and I seriously don't think it is a PL/SQL issue (that explains why I post it as a Database - Upgrade thread). Thanks.