Error ORA-21700 While Refreshing Materialized View (Doc ID 1304574.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 22-Jan-2013.

Symptoms

Once upgraded a destination instance, for example from 9i to 11g release,
then a Materialized View refresh fails with the errors:

SQL> execute DBMS_MVIEW.REFRESH('NOP_REP.HR_LOCATIONS_ALL','F');
BEGIN DBMS_MVIEW.REFRESH('NOP_REP.HR_LOCATIONS_ALL','F'); END;

*
ERROR at line 1:
ORA-12018: following error encountered during code generation for "NOP_REP"."HR_LOCATIONS_ALL"
ORA-21700: object does not exist or is marked for delete
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2545
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2751
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2720

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