My Oracle Support Banner

"ALTER VIEW ... COMPILE" Or "CREATE OR REPLACE VIEW ..." Failed With ORA-7445 [qctcpqbl()] (Doc ID 2516640.1)

Last updated on OCTOBER 11, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

If VIEW definition contains WITH clause, there is a possibility to get ORA-7445 when create or compile view.

  ORA-7445 [kghalo()+794]
  ORA-7445 [qctcpqbl()+84]

The Call Stack Trace in the associated incident trace file shows:

Changes

 Upgrade to 12c from 11g.

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.