ORA-979 After Upgrading To 10.2.0.4
Last updated on JULY 04, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
This problem can occur on any platform.
Getting Below ORA-979 error after upgrading to 10.2.0.4 from 9.2.
SQL> select inventory_item_id , count(mpc_header_id)
2 from xxvfp_dis_mpc_fso_vt
3 group by inventory_item_id;
group by inventory_item_id
ERROR at line 3:
ORA-979: not a GROUP BY expression
Errorstack could be similar to
ksdpec PGOSF95__ksfpec kgesev kgesec0 qcuErroer qcuErroep erroep VInfreq__qecgoc
VInfreq__qecgoc qecsel qecdrv kkqcttcalo kkqctdrvVM vopqbc vopqbc vopqbc vopdrv kkqctdrvTD
kkqdrv kkqctdrvIT apadrv opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms