ORA-600 [qsmkzsi_setup_ivqbc:1] with Materialized View COMPILE/REFRESH

Hi.

Just a quick post about issue that wasn’t ever discussed… and hasn’t fix from Oracle yet…

Compiling or refreshing materialized view You may face ORA-600 [qsmkzsi_setup_ivqbc:1] error.

It’s because of:

BUG 10145667 – ANSI query does not rewrite

Fixed In:

12.1. (future release)
11.2.0.4 (future release)

What is most interesting is that sometimes You may get mentioned error, but sometimes everything works as expected, so issue is not consistent…

Workaround:

Don’t use ANSI syntax!

Solution:

Wait for the fix for BUG 10145667 or move to 11.2.0.4,  12.1 when available.

References:

• Bug 10145667 – ANSI query does not rewrite
• Bug 13808560: ORA-600 [QSMKZSI_SETUP_IVQBC:1] WHEN COMPILING MATERIALIZED VIEW
• ORA-00600 [qsmkzsi_setup_ivqbc:1] when compiling Materialized View [ID 1429256.1]
• ORA-00600: [Qsmkzsi_setup_ivqbc:1] when compiling Materialized View [ID 1439560.1]