ORA-600  [hash aggregation can't be done], ORA-1652 on Temp Tablespace
Last updated on OCTOBER 25, 2017
Applies to:Oracle Server - Enterprise Edition - Version 10.2.0.1 to 10.2.0.2 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 06-APR-2012***
1). The following errors are encountered:
ORA-00600: internal error code, arguments: , [hash aggregation can't be done]
ORA-1652 on TEMP tablespace
2). The error is occurring on a SELECT statement with a GROUP BY clause.
3). The call stack may resemble:
ksfdmp kgeriv kgesiv ksesic1 qeshPartitionBuildHD qeshGBYOpenScan2 qeshGBYOpenScan qerghFetch qertqoFetch qerpxSlaveFetch qerpxFetch insdlexe insExecStmtExecIniEngine insexe
The database may have recently been upgraded from 10.1 to 10.2.
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