Mview Refresh Returns ORA-00979: Not A GROUP BY Expression
(Doc ID 2686945.1)
Last updated on JULY 03, 2020
Applies to:PL/SQL - Version 22.214.171.124 and later
Information in this document applies to any platform.
exec dbms_mview.refresh('<SCHEMA NAME>.<MVIEW NAME>','C');
ORA-12018: following error encountered during code generation for
"SCHEMA NAME"."<MVIEW NAME>"
ORA-00979: not a GROUP BY expression
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2821
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3058
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3017
ORA-06512: at line 1
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document