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

Thanks

Satya