ORA-600 [32695] [hash aggregation can't be done], ORA-1652 on Temp Tablespace

(Doc ID 418823.1)

Last updated on OCTOBER 25, 2017

Applies to:

Oracle Server - Enterprise Edition - Version to [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: [32695], [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