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:
12.1. (future release)
220.127.116.11 (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…
Don’t use ANSI syntax!
Wait for the fix for BUG 10145667 or move to 18.104.22.168, 12.1 when available.
- 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]