Materialized View Refresh Fails with ORA-12801 (Doc ID 437064.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.6 to 10.2.0.2 - Release: 9.2 to 10.2
Information in this document applies to any platform.

Symptoms

When creating a mview with build deferred option and master table contains
varchar2 (4000) column type on 10.2.0.2 RAC database from 9.2.0.6 as master site, leads to
failure of complete refresh after the creation with the following errors.

BEGIN dbms_mview.refresh('CLA_TABLE_SUBCASE','C'); END;

*
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-12801: error signaled in parallel query server
ORA-02063: preceding 2 lines from BIPDRA2.UAT.CO.UK
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms