Error ORA-21700 While Refreshing Materialized View
(Doc ID 1304574.1)
Last updated on JANUARY 15, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 22.214.171.124 [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
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