ORA-7445[kdzdcol_agg_cols_imc_generic()+24] when Querying INMEMORY MEMCOMPRESS Table
(Doc ID 2080334.1)
Last updated on FEBRUARY 27, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
When querying a table with INMEMORY MEMCOMPRESS attribute the following error occurs:
Meeting all of the following conditions may trigger this error:
- The 126.96.36.199.5 Database Bundle Patch or later has been applied
- Session stacksize limit (ulimit -s) is fairly small, e.g. 2048K
- Target table has INMEMORY MEMCOMPRESS attribute
- Query uses SUM() aggregate function
This does not reproduce in 12.2.
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