My Oracle Support Banner

After Installing PSU 11.2.0.3.7 Errors ORA-01741, ORA-00600 [kkzqid2fro], [733], [kkzgajdl_dltgen-0], ORA-07445 [kkzgiojt()+8] Occur During Fast Refresh of Certain Materialized Views (Doc ID 1573704.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Words 'materialized view' and mview are used interchangeably in this document.

Symptoms

After installing 11.2.0.3.7 PSU (<Patch 16619892>), fast refresh of certain materialized views errors out. All these refreshes worked without error prior to the application of the 11.2.0.3.7 PSU.

If the fast refresh has been initiated while no change needs to be applied to the mview (e.g. corresponding mview log(s) is (are) empty), then the refresh completes, but the following error is logged in the alert log:

ORA-01741: illegal zero-length identifier

Otherwise, the fast refresh may error out with ORA-600 error like the following during parsing the mview definition query:

ORA-00600 [kkzqid2fro]
ORA-00600 [733]
ORA-00600 [kkzgajdl_dltgen-0], []
ORA-07445 [kkzgiojt()+8]
ORA-00600 [kghstack_free1], [kkzgjctx:cta]
ORA-00600 [expecting modified table]

Note, you may also see the above errors while commit is done on the master table of an on commit materialized view, as the commit triggers fast refresh of the mview.

 

Changes

 11.2.0.3.7 PSU (<Patch 16619892>) has been applied.

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.