ANSI Join Fails With ORA-03113 and ORA-07445 [KKMEVW] (Doc ID 272324.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.5
This problem can occur on any platform.

Symptoms

Executing a ANSI join involving views gives error ORA-03113.

select *
from ((AGGR.LEG_SVOR_CUSTSERV_CURSTAT_DT T1
left outer join AGGR.LEG_GEO_BASEAREA_CURRENT_DV T2 on T1.BASE_AREA = T2.NPANXX)
left outer join AGGR.LEG_EMP_SIGNON_CALL_CENTER_VW T3 on T1.WRITTEN = T3.
EMP_SIGNON)
where (T1.LOAD_DATE >= sysdate -8);

In alert.log a corresponding ORA-07445 error is logged.

Stack trace: kkmevw kkmfcbvw kkmfcblo kkmpfcbk qcsprfro qcsfpaj qcsprfro qcsfpaj

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms