Error:
ORA-07445: exception encountered: core dump [qcdlaucn()+28] [SIGSEGV]
[ADDR:0x0] [PC:0x10688B03C] [Address not mapped to object] []
Error from alertlog file:
Sun May 13 01:36:06 2012
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0]
[PC:0x10688B03C, qcdlaucn()+28]
Errors in file
/dibidev1/app/db/11.1.0/admin/dibidev1_disvd322/diag/rdbms/dibidev1/dibidev1/trace/dibidev1_j005_994.trc
(incident=107572):
ORA-07445: exception encountered: core dump [qcdlaucn()+28] [SIGSEGV]
[ADDR:0x0] [PC:0x10688B03C] [Address not mapped to object] []
Incident details in:
/dibidev1/app/db/11.1.0/admin/dibidev1_disvd322/diag/rdbms/dibidev1/dibidev1/incident/incdir_107572/dibidev1_j005_994_i107572.trc
Information found from the
trace file:
----- Current SQL Statement for
this session (sql_id=aq52xz3mp63mn) -----
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO
"DDSAFM"."NA_PO_RELEASES_ALL" SELECT * FROM
PO_RELEASES_ALL@NAOATST1
Cause:
As per the metalink note [ID 1062771.1],
this occurred due to the column has been added to Materialized View base table
which is not yet reflected in the Materialized View syntax.
Resolution:
To fix the error,
we need to recreate the MVIEW with full column qualification in sub-SELECT
rather than using SELECT '*'. (after adding columns to base table of MVIEW). (see above Insert statement from trace file to understand clearly)
see example below:
CREATE MATERIALIZED VIEW INT.COMMV031
BUILD IMMEDIATE
REFRESH COMPLETE ON DEMAND
WITH rowid
AS
SELECT <col1>,<col2>,<col3> ... FROM <table_name>@<dblink>;
CREATE MATERIALIZED VIEW INT.COMMV031
BUILD IMMEDIATE
REFRESH COMPLETE ON DEMAND
WITH rowid
AS
SELECT <col1>,<col2>,<col3> ... FROM <table_name>@<dblink>;
Thanks
Satya
