ORA-7445 [QCDLAUCN] At Refresh MVIEW
(Doc ID 1062771.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.1.0.7 [Release 9.2 to 11.1]Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
INSERT statement, recursive of REFRESH MVIEW, fails with error:
ORA-07445: exception encountered: core dump [qcdlaucn()+28] [SIGSEGV] [ADDR:0x0] [PC:0x1068849BC]
Current SQL may show:
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO <MVIEW_NAME>
SELECT * FROM <table_name>@<dblink>;
SELECT * FROM <table_name>@<dblink>;
Call Stack in generated tracefile similar to:
... qcdlaucn qcsfbtacn qcsfaucn qcstda qcspsec qcspqb qcspqb ...
Changes
A column has been added to the MVIEW base table/s which is not yet reflected in the MVIEW syntax.
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |