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.412.1 when available.

References:

Advertisements

2 thoughts on “ORA-600 [qsmkzsi_setup_ivqbc:1] with Materialized View COMPILE/REFRESH

  1. Note: It is NOT fixed in 11.2.0.4!

    Support just gave me the same old workaround – seriously, this is not acceptable. Are they trying to drive their customers away?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s