ORA-7445 [qcsjRmCol] When Creating View From Base Table With Invisible Virtual Columns

(Doc ID 2337257.1)

Last updated on DECEMBER 22, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 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

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