ANALYZE WITH CASCADE OPTION FAILS WITH ORA-7445 [_INTEL_NEW_MEMCPY]
(Doc ID 1936815.1)
Last updated on FEBRUARY 22, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
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.
ANALYZE with CASCADE option fails with error
The current sql in the trace file is shown like
analyze table <table_name> validate structure cascade online
Note that the 'online' option is not essential. The call stack in the trace file includes functions like:
The ANALYZE TABLE 'table' VALIDATE STRUCTURE without option CASCADE does not fail. The ANALYZE INDEX 'index' VALIDATE STRUCTURE does not fail either for all available indexes.
The analyze statement fails after the adding some columns AND an update of some of these new columns in existing rows.
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