ORA-7445 [qcsjRmCol] When Creating View From Base Table With Invisible Virtual Columns
Last updated on DECEMBER 22, 2017
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
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
Stack Trace looks like:
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>';
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