Database DataWarehousing (MOSC)

MOSC Banner

Cannot Drop Materialized View

edited Sep 9, 2010 10:43PM in Database DataWarehousing (MOSC) 6 commentsAnswered
I have a materialized view that I moved to another schema for various reasons. When I try to drop the materialized view (drop materialized view command) it says that it has been dropped. However when I review the list of tables in that schema it still appears. If I try to drop it as a table I get an error stating that you cannot drop a materialized view in this way.
This is occurring on my test database so it's certainly not an emergency though it is driving me nuts! Thanks in advance for any help you can provide!

Matt Allen 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center