Forum Stats

  • 3,873,246 Users
  • 2,266,524 Discussions
  • 7,911,482 Comments

Discussions

Oracle 12c, ORA-00600 while creating mat.view

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Error report:

SQL Error: ORA-00600: internal error code, arguments: [qkswcWithQbcRefdByMain4], [], [], [], [], [], [], [], [], [], [], []

00600. 00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"

*Cause:   This is the generic internal error number for Oracle program

          exceptions.   This indicates that a process has encountered an

          exceptional condition.

*Action:  Report as a bug - the first argument is the internal error number

The code is:


create materialized view m_test

BUILD IMMEDIATE

REFRESH FORCE

ON DEMAND

ENABLE QUERY REWRITE

as

with

 tab1 as (

select...

)

,tab2 as (select ...)

select .. from tab2

Is there any workaround?

Tagged:

Answers

  • cormaco
    cormaco Member Posts: 2,039 Silver Crown

    The error message is about WITH. Try rewriting your query without the WITH clause.

    Other than that and contacting Oracle Support you could consider updating your database.

    User_UCA6R
  • User_UCA6R
    User_UCA6R Member Posts: 2 Green Ribbon

    Thank you very much!

    Unfortunately, it is very hard query with many CTE, and it will be a problem to rewrite it whitout WITH

  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown

    ORA-00600 is a generic 'unhandled exception' (aka: you hit a bug).

    And because you hit a bug, the only real recourse is to log on to your MOS account and search 'ora-00600'. That will bring up a lookup tool where you can enter the first argument from the error message, and your specific version of oracle. If that doesn't turn up anything useful, you will have to open an SR.