My Oracle Support Banner

Getting ORA-07445: Core Dump [kkfdqc] Error on UNION ALL View (Doc ID 1183993.1)

Last updated on FEBRUARY 24, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2.0 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database 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

On 11.2.0.1 production, the following error is occurring:

ORA-07445: exception encountered: core dump [kkfdqc()+176] [SIGSEGV]
[ADDR:0x28] [PC:0x104611FB0] [Invalid permissions for mapped object] []
when a select from a view is performed:

SELECT * FROM TSTSCHEMA."TEST_ASSIGNMENTS_V";


----- PL/SQL Call Stack -----
object line object
handle number name
700000035f2c900 1053 package body SYS.DBMS_SQL
700000035fd1340 868 package body TEST.TEST_UTILS
7000000340d0250 1 anonymous block

Select query of view TEST_ASSIGNMENTS_V is failing


SQL> SELECT pga.row_id, pga.po_header_id, ou.NAME, pga.organization_id,
pga.enabled_flag, pvs.vendor_id, pvs.vendor_site_id, pvs.vendor_site_code,
DECODE (pga.organization_id, poh.org_id, 1, 2), pga.last_update_date, pga.last_updated_by, pga.creation_date, pga.created_by, pga.last_update_login, ou2.NAME, pga.purchasing_org_id
FROM TEST1 ou, TEST2 ou2, TEST3 pvs,
TEST_ASSIGNMENTS pga, TEST_HEADR poh
WHERE pga.po_header_id = poh.po_header_id
AND pga.organization_id = ou.organization_id
AND pga.vendor_site_id = pvs.vendor_site_id
AND pga.purchasing_org_id = ou2.organization_id
/
 SELECT pga.row_id, pga.po_header_id, ou.NAME, pga.organization_id,
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


  VIEW TEST_ASSIGNMENTS_V contains the problematic column row_id which is
filled in from TEST_ASSIGNMENTS

CREATE OR REPLACE VIEW TEST_ASSIGNMENTS (row_id,
po_header_id,
organization_id,
enabled_flag,
vendor_site_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
purchasing_org_id
)
AS
SELECT /*+ PUSH_JOIN_PRED */
CHARTOROWID (ROWIDTOCHAR (ROWID)) row_id, "PO_HEADER_ID",
"ORGANIZATION_ID", "ENABLED_FLAG", "VENDOR_SITE_ID",
"LAST_UPDATE_DATE", "LAST_UPDATED_BY", "CREATION_DATE",
 "CREATED_BY", "LAST_UPDATE_LOGIN", "PURCHASING_ORG_ID"
FROM "PO"."TEST_ASSIGNMENTS"@TEST0001h
UNION ALL
SELECT /*+ PUSH_JOIN_PRED */
CHARTOROWID (ROWIDTOCHAR (ROWID)) row_id, "PO_HEADER_ID",
"ORGANIZATION_ID", "ENABLED_FLAG", "VENDOR_SITE_ID",
"LAST_UPDATE_DATE", "LAST_UPDATED_BY", "CREATION_DATE",
 "CREATED_BY", "LAST_UPDATE_LOGIN", "PURCHASING_ORG_ID"
FROM "PO"."TEST_ASSIGNMENTS"
WITH READ ONLY

Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.