My Oracle Support Banner

ORA-7445 [qcsjRmCol] When Creating View From Base Table With Invisible Virtual Columns (Doc ID 2337257.1)

Last updated on OCTOBER 11, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Create or replace view fails with:

ORA-07445: exception encountered: core dump [qcsjRmCol()+4] [SIGSEGV] [ADDR:0x0] [PC:0x10CA79C64] [Address not mapped to object] []

----- Current SQL Statement for this session -----

CREATE OR REPLACE VIEW xxxxx.xxx
AS
SELECT...

Stack Trace looks like:

...qcsjRmCol qcsjRmCol qcsjgcn qcsjgcn qcsjgcn qcsfajcn qcsIsColInFro qcsRslvColWithinQbc qcsStrongColRslv qcsRslvCol qcsRslvName qcsridn qcspqbDescendents qcspqb qcsevw qcsfpsq kkmfcbsq kkmpfcbk qcsprfro qcsprfro_tree qcsprfro_tree qcspafq qcspqbDescendents qcspqb qcsevw qcsfpsq kkmfcbsq kkmpfcbk qcsprfro qcsprfro_tree qcsprfro_tree qcsprfro_tree qcspafq...

 

Changes

Base table in select  contain invisible virtual columns.

To identify the invisible columns, use:

SQL> select TABLE_NAME,COLUMN_NAME,COLUMN_ID from dba_tab_cols where HIDDEN_COLUMN='YES' and owner='<schema_name>';

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


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