ORA-600 [32695] [hash aggregation can't be done], ORA-1652 on Temp Tablespace (Doc ID 418823.1)

Last updated on JUNE 13, 2013

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***


Symptoms

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

Changes

The database may have recently been upgraded from 10.1 to 10.2. 

Cause

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