Error ORA-21700 While Refreshing Materialized View
Last updated on FEBRUARY 02, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 18.104.22.168 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 22-Jan-2013.
Once upgraded a destination instance, for example from 9i to 11g release,
then a Materialized View refresh fails with the errors:
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
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