My Oracle Support Banner

Drop Materialized View Failed With ORA-701 (Doc ID 853962.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Aug-2012***


Symptoms

Reported ORA-701: object necessary for warmstarting database cannot be altered
when trying to drop an mv that has been compiled and was based on system tables

ERROR at line 1:

ORA-00701: object necessary for warmstarting database cannot be altered

Example Mview DDL:-

CREATE MATERIALIZED VIEW OBJECTS BUILD IMMEDIATE REFRESH FORCE ON DEMAND WITH PRIMARY KEY AS
SELECT object_name OBJECT, last_ddl_time updatetime
FROM all_objects WHERE object_name = 'TEST'
AND owner = 'TEST' AND object_type = 'MATERIALIZED VIEW'



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
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.